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.
Click on the row below the one that you want to remain visible. Then Freeze
Panes from the 'Window' menu.
HTH,
Paul
"AnneG" <AnneG@discussions.microsoft.com> wrote in message
news:5F274A85-D850-4D35-AB4C-110E9FC151AD@microsoft.com...
> 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.