Alternate Strategy: You can use the Freeze Panes command on the View tab. In order to make the Freeze Panes command work, you must place the cell pointer in the correct location before using the command.
In the spreadsheet shown in Figure 68 it would be really handy to have row 3 always visible while you scroll. Here’s how you make that happen:
1. Use the arrow at the bottom of the vertical scrollbar to move row 3 to the top of the window.
2. Place the cell pointer in cell A4. You’re going to use the Freeze Panes command, which will freeze all visible rows above the cell pointer and all visible columns to the left of the cell pointer. If you place the cell pointer on the heading for column A, you will not freeze any columns, only the rows.
Figure 70 Cells above and left of the active cell is frozen.
3. With the cell pointer in cell A4, select View , Freeze Panes , Freeze Panes. A solid horizontal line will be drawn between rows 3 and 4. As you scroll down, you will always be able to see the heading rows.
Additional Details: To turn off this feature, go to the View tab and select Freeze Panes, Unfreeze Panes. The Unfreeze Panes menu item is visible only after you have frozen the panes.