Freezing Panes for both Rows and Columns

[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.

 

[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.

 

[MetalUrge]

Wow, that was fast. Thanks a lot bro. It surely did solve my issue.:

 

[Guest]

Thanks for the feedback!!

Andy.

 

[Mike Cawood, HND BIT]

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.

You right click the one cell below and to the right of the columns you wish
to freeze.
Regards Mike.

 

[Mike Cawood, HND BIT]

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.

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.