freeze more than one row within a spreadhsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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
 
Thanks!!!!! :-)

JR Hester said:
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
Click to expand...
 
Back
Top