In Microsoft Excel 2007, you have the ability to freeze the top row of the spreadsheet so that you always see the labels and headers in the first row at all times. This way when you scroll down on a very long spreadsheet, you don’t have to guess what column you are looking at. You will always see the first row and your column header.
First, open Excel 2007 on your computer. At the top of the Office Ribbon, click on the “View” tab.
Simply click the “Freeze Panes” button and you will see this drop down. Now click the “Freeze Top Row” to freeze the top row so it is always in view.
Scroll down your document and the top row is always frozen.
NOTE: If you save this document with the top row frozen you can open it in an earlier version of Excel and the top row will still be frozen.
great tips
What about to freeze the top 3 rows?
I have the main page header on the top row, then I have the column headers, then I need a blank gap with a set height. Rows 4 and on will be where the data is held.
@Steven – Here’s what you do:
Since your data will start on the 4th row and you want to freeze the top 3 rows, select the first cell in row 4.
Now click on the “View” tab in the ribbon and click on the “Freeze Panes” button and then click the “Freeze Panes” option.
You should now see a line appear separating the 3rd and 4th rows. Now when you scroll down the spreadsheet the top 3 rows should stay in place.
Hope I explained that clear enough.
very useful. thanks
Thank you THE PRO. You answered everything… got me a %100 on the test instead of a %95. Thanks again
>
Great stuff! Thanks very much. Just what I was looking for…