Special Edition Using Microsoft® Office XP

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