Locking Headings in Place with Freeze Panes

In most worksheets, you type a label at the top of each column or to the left of each row to indicate the type of data in each cell. When you're typing data entries in a column or row, these labels help you figure out what you need to type in each cell . Unfortunately, as you scroll down or to the right, your column and row headings scroll outside the viewing area. To keep them onscreen, you can freeze the columns or rows by following these steps:

1. Click the cell that's directly below the row(s) you want to freeze and to the right of the column(s) you want to freeze, as shown in Figure 5.6.

   Figure 5.6. Choose the cell below the rows and to the right of the columns you want to freeze.

   

2. Open the Window menu and choose Freeze Panes . A dark line appears below the frozen rows and to the right of the frozen columns. The frozen rows and columns remain onscreen at all times.

To unlock the panes, first make sure the worksheet with the frozen panes is displayed. (The cell selector can be anywhere on the worksheet.) Open the Window menu and choose Unfreeze Panes .