How to fix or freeze header in Microsoft Excel 2007?

In Microsoft Excel 2007, you can freeze the top row of the spreadsheet so that you always see the top headers in the first row at all times. When you are working with a very long spread sheet, Freezing Headers helps to work faster and better.

Steps to freeze header in Microsoft Excel 2007:

1. Open Microsoft Excel 2007 on your computer. At the top of the Office Ribbon, click on the “View” tab.
2. Click the “Freeze Panes” button and you will see a drop down. Now click the “Freeze Top Row” to freeze the top row.

Scroll down your document and the top row is always frozen.