Microsoft Excel 2007 is a spreadsheet processing application that comes as a part of the Microsoft Office 2007 suite. This edition of the Office programs introduced a significant change to the user interface. As a result, many users proficient in earlier versions of Excel find themselves lost when it comes to trickier functions, such as copying worksheets or freezing rows. Fortunately, most of the options are still easy to access, you just need to know how to get to them.
Select the row below the row or group of rows you want to freeze by clicking the row number in the left section of the spreadsheet.
Select the "View" option in the main menu area on top of Excel window.
Click the arrow on "Freeze Panes" drop-down menu in the "Window" group and select "Freeze Top Row."