freeze more than one row within a spreadhsheet

[Mari]

Hello,
I have one row already frozen (the very first row of my spreadsheet) and I'm
trying to freeze another one. Is it possible to freeze more than one row
within the same spreadsheet?
Thanks!

 

[Gord Dibben]

Only contiguous rows starting at the top can be frozen.

Select A3 to freeze rows 1 and 2

B3 to freeze column A and rows 1 and 2


Gord Dibben MS Excel MVP

 

[JR Hester]

You may FREEZE multiple rows and/or columns, as long as they are contigous.
First you must UNFREEZE the row you Froze. Then place actie cell below and to
the right of of teh rows/columns you wish to freeze in place.

HTH

 

[David Biddulph]

Only contiguous rows at the top.

 

[Mari]

Thanks!!!!!

You may FREEZE multiple rows and/or columns, as long as they are contigous.
First you must UNFREEZE the row you Froze. Then place actie cell below and to
the right of of teh rows/columns you wish to freeze in place.

HTH