• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Structuring the Sheet > Freezing the Headings

Freezing the Headings

To keep the column and row headings from scrolling off the screen while you scroll through a large worksheet, you can freeze the headings.

To freeze the headings:

1.
Click the cell at the upper left corner of the region that contains the data.

2.
From the Window menu, choose Freeze Panes.

Lines appear to indicate which areas of the sheet will stay frozen as you scroll through the data (Figures 12.17 and 12.18).

Figure 12.17. Lines appear to indicate which areas of the sheet are frozen.


Figure 12.18. The headings in Column A will stay frozen as you scroll through the data.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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