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

Chapter 19. Excel Essentials > Customizing the Worksheet Window

Customizing the Worksheet Window

Changing the size and configuration of a worksheet window can make it easier to work with data, especially in large worksheets. Zoom out or in to show more or less data, lock a row or column in place to maintain titles and headings, work in multiple panes, or open a new window on the same workbook.

Using the Zoom Controls

Use the Zoom button on the Standard toolbar to change the view of your worksheet. Most of the options are self-explanatory: You can shrink the worksheet to as small as 10% of normal size for an overview of the sheet's design, or enlarge it to as much as 400% of normal (this option is especially useful for close editing of complex grouped objects on a sheet). If you choose a Zoom level of 39% or lower, your gridlines will disappear. That's not a bug—at the lower magnification, the lines get in the way of your ability to edit, so Excel hides them on the screen.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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