Freezing Rows in Excel

May 27, 2003 - by Bill Jelen

Roberto asks again,

When I scroll down through the hundreds of rows on my spreadsheet, I always want to see the headings in Row 1. How can I do this?

Scroll to the top of the spreadsheet so that you can see rows 1 and 2. Click in cell A2 so that this is the activecell.

From the menu, select Window > Freeze Panes. Anything visible on the screen above the activecell will be visible as you scroll through the worksheet. Also note that anything visible on the screen to the left of the activecell would remain locked as you scrolled across the columns. Since you only wanted to freeze row 1, it was important to have the cell pointer in column A, so that no columns were included in the Frozen section of the worksheet.