Page 193 - Excel Timesaving Techniques for Dummies

37_574272 ch32.qxd 10/1/04 10:52 PM Page 178
178
Technique 32: Controlling the Worksheet Window Display
When setting a new magnification using the Zoom 2. Either select Selection on the Zoom combo
combo box or the Zoom dialog box, you can select box’s pop-up menu on the Standard toolbar or
one of the preset magnification percentages — 200%, click the Fit Selection option button in the
100%, 75%, 50%, and 25%, with 100% being the Zoom dialog box (View➪Zoom).
default setting for all worksheets — from its drop-
down list. (Of course, the size of the cells at the Figures 32-1 and 32-2 illustrate this type of situation.
100% setting can vary, depending on the current In Figure 32-1, I select the cell range J20:L25 — the
resolution and the overall size of your monitor’s range that needs editing — and then click the
screen.) Selection option from the Zoom combo box on the
Standard toolbar.
You can also enter a custom percentage between
a minimum of 10% and a maximum of 400%:

To do this in the Zoom combo box, click the
combo box, enter the new value, and then press
the Enter key.
To set a custom percentage in the Zoom dialog
box, open the Zoom dialog box (View➪Zoom),
click the Custom text box, type a new percent-
age, and click OK.

If you have a Microsoft IntelliMouse, you can
set it up in Excel so that rolling the wheel back
and forth zooms out and in on the current
worksheet. On the General tab of the Options
dialog box (Tools➪Options), select the Zoom
on Roll with IntelliMouse check box. After- • Figure 32-1: Selecting the cell range to zoom in on with
wards, rolling the wheel backward increases
the Fit Selection feature.
the magnification by 15% until you reach the
maximum 400%, whereas rolling the wheel
Figure 32-2 shows the results of this action. To dis-
forward decreases the magnification by 15%
until you reach the minimum 10% value. play only this cell range in the worksheet window,
Excel automatically selects a new magnification set-
When editing a range of cells, I often find the Fit ting of 179%. After editing the cells in this range,
I can then return to the normal magnification by
Selection option (abbreviated to Selection on the
Zoom pop-up menu) to be the most useful because selecting 100% from the Zoom combo box.
this feature automatically selects whatever magnifi-
cation is necessary to display all the cells currently Zoom out to locate the cell range to be edited
on the worksheet. Then select the range and
selected. To use this feature, follow these steps:
use the Fit Selection feature to display it full-
screen as you make the necessary editing
1. Select the range of cells that must be displayed changes.
for the type of editing you’re doing.