How do I freeze a row other than the top one?
 

My column headers are rarely in the top row of a spreadsheet. How do I
freeze the header row so that I can still see it as I scroll down the page?
This seems to have changed in Excel 2007.

How do I freeze a row other than the top one?
 

Click on the row below the one that you want to remain visible. Then Freeze
Panes from the 'Window' menu.

HTH,
Paul

"AnneG" wrote in message
...
My column headers are rarely in the top row of a spreadsheet. How do I
freeze the header row so that I can still see it as I scroll down the
page?
This seems to have changed in Excel 2007.