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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to freeze panes 16
Freeze/split more than one row 2
Excel 2007 - freeze multiple panes? 2
freeze row AND column simultaneously 3
Freeze multiple rows/columns in Excel 2007 11
PowerPoint Freeze animation 1
Help Freezing Multiple Rows 3
Help freezing multiple top rows 2

Back
Top