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

Part IV: Optimizing Excel > Managing the Worksheet Display

Chapter 20. Managing the Worksheet Display

  • Screen display

    Many elements of the worksheet display can be modified or removed to customize the appearance of your screen.

  • Full Screen view

    Full Screen view temporarily hides many of the display elements to make more room for your worksheet.

  • Custom Views

    Custom Views enable you to save custom display settings with a name so you can quickly switch from one custom view to another.

  • Multiple panes

    View two to four parts of a worksheet simultaneously by viewing a worksheet window through multiple panes. Using panes, you can freeze row and column headings as you scroll through a worksheet.

  • Multiple windows

    Work with and view more than one worksheet at a time by opening multiple windows and arranging the windows on your screen.

With very little effort, you can change the way Excel displays its sheets. If you like to see a lot of the worksheet, you can reduce the size of a worksheet to see more landscape. If you need to arrange multiple workbooks or worksheets so you can see and move between them easily, you can. You can split a worksheet and freeze parts so that they don't scroll.

One of Excel's most important display features is how the Custom Views command can save and restore different views of a worksheet. This enables you to set up display and print settings and assign those settings to a name. Whenever you want to return to the Data Entry view, for example, you can select Data Entry from the Custom Views dialog box. If you have certain print settings and ranges for one report that are different from the print settings and ranges for another report, assign each of these combinations of views and settings to a name in the Custom Views dialog box. When you want to return to that view and settings, just select the appropriate name from the Custom Views dialog box. Let it handle the job of changing display settings and moving to the correct locations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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