Show Me Microsoft Office 2003

Once you've finished creating the worksheet structure ”labels and formulas ”you're ready to enter data. The first six columns and twelve rows or so are just fine, but as you scroll to enter data in later columns or rows, the labels for the column headings shift out of view. Instead of memorizing the headings, freeze the label columns and rows so they remain visible as you scroll through the rest of the worksheet. You can freeze a row, a column, or a pane from a split worksheet.

Freeze Columns and Rows

Click the cell that intersects the rows and columns you want to remain visible on the screen.

To freeze panes from a split window, skip step 1.

Click the Window menu, and then click Freeze Panes.

Edit and scroll the worksheet as usual.

Unfreeze Columns and Rows

Click the worksheet that you want to unfreeze.

Click the Window menu, and then click Unfreeze Panes.