totn Excel

MS Excel 2003: Freeze first row and first column

This Excel tutorial explains how to freeze panes to keep the first row and first column visible when scrolling in Excel 2003 and older versions (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2003/XP/2000/97, I have a spreadsheet with column headings. I need to freeze the first row and also freeze the first column. That way, I can see the first row and first column at all times even when I scroll. How can I do this?

Answer: If you need to see the first column (column A) and first row (row 1) even after scrolling, you could try freezing the pane in Excel.

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

To freeze the first row and column, open your Excel spreadsheet.

Select cell B2. Then under the Window menu, select Freeze Panes.

Microsoft Excel

Now when you scroll, you should still continue to see row 1 and column A.

Microsoft Excel