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.