O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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% ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required