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

Part 2. Managing and Viewing Workbooks > Freezing Rows and Columns

Freezing Rows and Columns

Click in the cell to the right of and below the area you want to freeze. (Typically this is cell B2 if your main header row is Row 1 and your main column is Column A.

Click Freeze Panes.

Using the keyboard arrow keys, move through the worksheet. Notice the frozen rows and columns you selected enable you to reference data with the appropriate titles.

Open the Window menu and select Unfreeze Panes to unfreeze the columns and rows.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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