freeze other columns when columns have been frozen already

[Guest]

I'm trying to freeze a column after i've froze a row,and when i go to window
the only option i have left is "unfreeze panes". Can somebody explain to me
how to do it?thanks.

 

[Gord Dibben]

The freeze line is above and to the left of where you select a cell.

Columns and rows must be "frozen" at the same time.

i.e. to freeze row 1 and column A select B2 and Window>Freeze Panes.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 15:36:02 -0700, "Freeze column" <Freeze