Freezing Panes for both Rows and Columns

M

MetalUrge

Is it possible to freeze desired Rows and Columns at the same time? I've
tried it, but once either the Row or Column is freezed, the other cannot
be done as when right-clicked it shows unfreeze.
 
G

Guest

Hi

Yes! For example, if you select cell B2 and Windows/Freeze Panes, the first
row and the first column will be frozen.

Hope this helps.
Andy.
 
M

Mike Cawood, HND BIT

MetalUrge said:
Is it possible to freeze desired Rows and Columns at the same time? I've
tried it, but once either the Row or Column is freezed, the other cannot
be done as when right-clicked it shows unfreeze.
Click to expand...
You right click the one cell below and to the right of the columns you wish
to freeze.
Regards Mike.
 
M

Mike Cawood, HND BIT

MetalUrge said:
Is it possible to freeze desired Rows and Columns at the same time? I've
tried it, but once either the Row or Column is freezed, the other cannot
be done as when right-clicked it shows unfreeze.
Click to expand...

You select the one cell below and to the right of the row & column you wish
to freeze and then pull down the Window menu & select Freeze Panes.
Regards Mike.
 
Top