totn Excel

MS Excel 2007: Freeze top row

This Excel tutorial explains how to freeze panes to keep the top row visible when scrolling in Excel 2007 (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2007, I have a spreadsheet with column headings. I need a way to scroll down the rows, but still see the column headings that are contained in the top row. How can I do this?

Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel.

NOTE: Freezing panes only works when you are in Normal View.

To freeze the top row, open your Excel spreadsheet.

Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Top Row option in the popup menu.

Microsoft Excel

Now when you scroll down, you should still continue to see the column headings.

Microsoft Excel