Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Managing Worksheet Views
Someone once wrote about the
importance of seeing and being seen. Although I’m
sure that quote referred to people, it also can
apply to your Excel worksheets. You need to see
them in many contexts. That’s what this section
does—shows you your worksheets from different
You can also use the Zoom control slider to
manually set the magnification. Drag the Zoom slider
bar to the right to increase magnification or drag it
to the left to decrease magnification. Click the
Zoom In or Zoom Out buttons on the Zoom
control slider, which changes the magnification
percentage by 10% for each click of the Zoom In
button (see Figure 11-14). The Zoom percentage
displays on the Status bar.
Zooming In or Out
The Zoom feature enlarges or shrinks the display of
your worksheet to allow you to see more or less of
it. Excel can zoom your worksheet in percentages,
with the normal display of your worksheet being
100%. Zooming in or out does not affect printing.
Chapter 4, “Managing Word Pages,” shows you
zooming in on a Microsoft Word document.
View icons Zoom control slider
Choose View>Zoom>Zoom or click the Zoom level
button next to the status bar Zoom controls. The
Zoom level button displays the current zoom
percentage. Select a magnification percentage from
the Zoom dialog box. A higher zoom setting makes
the text appear larger so you see less on the
screen; a lower setting shows more on the screen,
but the data appears smaller. Click OK.
Figure 11-14
Zooming in on your data using the Zoom controls.
View Icons
On the Status bar, next to the Zoom controls,
you find three View icons you can use to
quickly switch among the Normal view, Page
Layout view, and Page Break Preview modes.
Custom Options
Select the Custom option and enter your
own setting from 10% to 400%.
Search JabSto ::

Custom Search