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

G

Guest

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

PCLIVE

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

HTH,
Paul
 

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

Freeze the side column/top row & scroll others 2
Split / Freeze Pane's 3
Unable to freeze panes 16
Trouble Freezing Panes in Excel 2003 2
Excel 2007 - freeze multiple panes? 2
Freeze pane 3
How do I make JUST the header row always visible in Excel? 2
Freeze top 2 rows - how 3

Top