Microsoft Office Tutorials and References
In Depth Information
Zooming In on a Worksheet
One way to make Excel easier to work with is to change the program’s zoom level. Just
as you can “zoom in” with a camera to increase the size of an object in the camera’s
viewer, you can use the zoom setting to change the size of objects within the Excel 2010
program window. For example, if Peter Villadsen, the Consolidated Messenger European
Distribution Center Manager, displayed a worksheet that summarized his distribution
center’s package volume by month, he could click the View tab and then, in the Zoom
group, click the Zoom button to display the Zoom dialog box. The Zoom dialog box
contains controls that he can use to select a preset magnification level or to type in
a custom magnification level. He could also use the Zoom control in the lower-right
corner of the Excel 2010 window.
Clicking the Zoom In control increases the size of items in the program window by
10 percent, whereas clicking the Zoom Out control decreases the size of items in the
program window by 10 percent. If you want more fine-grained control of your zoom
level, you can use the slider control to select a specific zoom level or click the
magnification level indicator, which indicates the zoom percentage, and use the Zoom dialog
box to set a custom magnification level.
The Zoom group on the View tab also contains the Zoom To Selection button, which
ills the program window with the contents of any selected cells, up to the program’s
maximum zoom level of 400 percent.
Tip The minimum zoom level in Excel 2010 is 10 percent.