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

A

AnneG

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

How do I freeze the swimlane headers? 0
Repeating a row other than the 1st row as the header row in a table from next page 1
How do I remove the top half of a block interval? 1
Freeze the side column/top row & scroll others 2
Unable to freeze panes 15
Format column widths from one table to a separate table on same page 1
Need Help with a VBA subroutine 0
sqlite-odbc write conflict 2

Top