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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Freezing top and bottom rows 5
How do I make JUST the header row always visible in Excel? 2
Trouble Freezing Panes in Excel 2003 2
Unable to freeze panes 16
How do I freeze a row in Excel 2003 ? 1
locking multiple rows in excel 03 2

Back
Top