Datasheet

The Excel Options dialog

box appears.

3 Click the Advanced tab.

1 Click the File tab button.

2 Click Options.

If you frequently zoom in or out of a

worksheet, you can save time by configuring

Excel to enable you to zoom using the wheel

on your mouse.

Zooming a worksheet is a useful technique.

For example, you might want to zoom out of a

large worksheet to get a sense of the overall

structure of the worksheet data. Similarly,

zooming in on a section of a worksheet enables

you to focus on just that section.

You normally zoom either by using the

controls in the View tab’s Zoom group, or by

using the Zoom slider that appears in the

bottom-right corner of the Excel window.

These techniques are fine if you only zoom

occasionally. However, if you use the zoom

feature frequently, it is a good idea to configure

Excel to zoom using the mouse wheel.

Configure Excel to Use the

Mouse Wheel for Zooming

03_577769-ch01.indd 1203_577769-ch01.indd 12 3/27/10 9:00 AM3/27/10 9:00 AM