The Excel zoom feature changes the scale that a spreadsheet is viewed electronically. This does not change the underlying characteristics of your spreadsheet, and so a printout of the spreadsheet will remain the same, regardless of the selected zoom level.
In Excel 2007 and later versions of Excel, the main Zoom option is located in the View tab, and in Excel 2003, the Zoom... option can be found in the View drop-down menu.
Selecting the Excel Zoom option causes the Zoom options dialog box to pop up. This dialog box gives you the option to select a set magnification (eg. 200%, 400%, etc.), or to specify a magnification of your own.
The Zoom dialog box also gives you the option to zoom to selection, which adjusts the zoom scale to fit any currently selected cells into the current view.
Shortcuts to some of these options are presented on the ribbon in Excel 2007 and later versions of Excel, or on the formatting toolbar in Excel 2003.
If you zoom your Excel worksheet to less than 40%, Excel automatically displays all your named ranges, as shown in the above image on the left.
If, at any time, you want to quickly access the zoom dialog box, you can simply press:
Alternatively, if you have a mouse with a roller wheel, you can activate the Excel option Zoom on roll with IntelliMouse. This enables the user to zoom in or out of a spreadsheet by rolling the wheel on the mouse up or down.
The Zoom on roll with IntelliMouse option is found in the following locations: