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

200 A Spreadsheet with a View
If the device you’re running Excel 2013 on is equipped with a physical mouse with a wheel in between the two mouse buttons (sometimes referred to as an IntelliMouse), you can set it up in Excel so that rolling the wheel back
and forth zooms out and in on the current worksheet. To do this, click the Zoom on Roll with IntelliMouse check box in the Editing Options section of the Advanced tab of the Excel Options dialog box (File➪Options➪Advanced or Alt+FTA). After you select this check box, instead of scrolling up the rows of the worksheet, rolling the wheel forward increases the magnification (by 15% until you reach the maximum 400%). Instead of scrolling down the rows of the sheet, rolling the wheel backward decreases the magnification (by 15% until you reach the minimum 10% value).
Figures 3-8 and 3-9 illustrate how you can use the Zoom feature to first zoom out to locate a region in a large spreadsheet that needs editing and then zoom in on the region to do the editing. In Figure 3-8, I zoomed out on the Income Analysis to display all its data by selecting a 50% magnification set- ting. (I actually did this by dragging the Zoom slider button to the left until 50% appeared on the status bar to the left of the Zoom Out button.) At the 50% setting, I could just barely make out the headings and read the numbers in the cells. I then located the cells that needed editing and selected their cell range (J20:L25) in the worksheet.
Figure 3-8:
The Income Analysis worksheet after zooming out toa50% magnifica- tion setting.