Excel 2010 Bible

Chapter 3: Essential Worksheet Operations

59

Zooming in or out for a better view ...........................................................................

Normally, everything you see onscreen is displayed at 100%. You can change the zoom percentage

from 10% (very tiny) to 400% (huge). Using a small zoom percentage can help you to get a bird’s-

eye view of your worksheet to see how it’s laid out. Zooming in is useful if your eyesight isn’t quite

what it used to be and you have trouble deciphering tiny type. Zooming doesn’t change the font

size, so it has no effect on printed output.

Cross-Reference
Excel contains separate options for changing the size of your printed output. (Use the controls in the Page
Layout ➪ Scale to Fit ribbon group.) See Chapter 9 for details. n

Figure 3.5 shows a window zoomed to 10% and a window zoomed to 400%.

FIGURE 3.5

You can zoom in or out for a different view of your worksheets.

You can easily change the zoom factor of the active worksheet by using the Zoom slider located on

the right side of the status bar. Click and drag the slider, and your screen transforms instantly.

Another way to zoom is to choose View ➪ Zoom ➪ Zoom, which displays a dialog box. Choosing

View ➪ Zoom ➪ Zoom to Selection zooms the worksheet to display only the selected cells (useful

if you want a particular range of cells to fill the workbook window).