freeze more than one row within a spreadhsheet

M

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!
 
G

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
 
J

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
 
M

Mari

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