Freeze the top row in Microsoft Excel 2007

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.

Excel 2007 Tabs

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.

Freeze Top Row

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

Note 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.

This entry was posted in Microsoft Office and tagged , , , , , , . Bookmark the permalink.

6 Responses to Freeze the top row in Microsoft Excel 2007

  1. Nitin Khare says:

    great tips

  2. Steven says:

    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.

  3. The Pro says:

    @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.

  4. Ehsan says:

    very useful. thanks

  5. Vince says:

    Thank you THE PRO. You answered everything… got me a %100 on the test instead of a %95. Thanks again :D >

  6. Fish4Phones says:

    Great stuff! Thanks very much. Just what I was looking for…

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>