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

Chapter 10. Formatting Worksheets > Working with Large Sheets

Working with Large Sheets

There are two helpful procedures you can use when working with large worksheets. First, you can freeze column and/or row headings to prevent their information from moving offscreen when you scroll. Second, you can split a worksheet into multiple panes. Doing so enables you to display and independently scroll through two or four regions of the worksheet. You can split a sheet horizontally, vertically, or in both directions.

To freeze column and/or row headings

1.
Do one of the following (Figure 10.10):

  • To freeze only rows, click the row heading that is immediately below the rows you want to freeze.

  • To freeze only columns, click the column heading that is immediately to the right of the columns you want to freeze.

  • To freeze both rows and columns, select the cell immediately below and to the right of the rows and columns you want to freeze.

Figure 10.10. To freeze the top row of column headings, select row 2. To freeze the Date column (A), select column B. To freeze both, select cell B2.


2.
Choose Window > Freeze Panes.

Gray lines appear in the worksheet to mark the frozen areas (Figure 10.11).

Figure 10.11. In this worksheet, both row 1 and column A are frozen. No matter what direction you scroll, row 1 and column A will remain onscreen.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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