Page 217 - Excel 2013 All-in-One For Dummies

A Spreadsheet with a View 199
“Zoom, zoom, zoom”
Excel 2013 makes it really easy to see more data in the active worksheet window with its Zoom slider feature on the Status bar in the lower-right corner of the window. The Zoom slider contains two buttons on either end: a Zoom Out button on the left side that reduces the Worksheet area’s magnifi- cation percentage by 10 percent each time you click it and a Zoom In button on the right side that increases the Worksheet area’s magnification percent- age by 10 percent each time you click it. You can also quickly change the Worksheet area’s magnification percentage (and thus zoom out and in on the data) by dragging the slider’s button to the left or right.
Note that the Zoom slider button is always located in the very center of the Zoom slider, putting the Worksheet area magnification at 100% (the normal screen, depending upon your computer monitor’s screen resolution) when you first open the worksheet. As you click the Zoom Out or Zoom In button or drag the slider button, Excel keeps you informed of the current magni- fication percentage by displaying it to the immediate left of the Zoom Out button on the status bar. Note too, that 10% is the lowest percentage you can select by dragging the button all the way to the left on the slider, and 400% is the highest percentage you can select by dragging the button all the way to the right.
On a touchscreen device, you can use your fingers to zoom in and out on a worksheet. Simply stretch your forefinger and thumb out to zoom in on the cells and pinch them together to zoom out. As you do, the Zoom slider on the status bar shows you the currently selected zoom percentage and moves the slider right or left to follow your stretch or pinch gesture.
Although the Zoom slider is always available on the status bar in any work- sheet you have open, you can change the Worksheet area’s magnification percentage by clicking the Zoom button on the Ribbon’s View tab or by pressing Alt+WQ. Doing this opens the Zoom dialog box, where you can select preset magnification percentages 200%, 100%, 75%, 50%, and 25% by clicking its option button before you click OK. In addition, you may enter any magnification percentage between a minimum of 10% and a maximum of 400% by clicking its Custom options button and entering the percentage in its text box before you click OK.
You can also have Excel change the magnification to suit the cell range
that you’ve selected. To do this, select your cell range, click the Zoom to Selection button on the View tab, or press Alt+WG. Note that you can also do this same thing by clicking the Fit Selection option button when the Zoom dialog box is open before you click OK.
Book II Chapter 3
Editing and Proofing Worksheets