See solution in other versions of Excel:
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. 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. To do this, open your Excel spreadsheet.
Select cell B2. Then under the Window menu, select Freeze Panes.
Now when you scroll, you should still continue to see the row 1 and column A.