• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Freezing Panes

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint