Excel Zoom

Excel 2010 Zoom Options

Excel Zoom Menu

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 remains constant, regardless of the selected zoom level.

In Excel 2007 or Excel 2010, the main Zoom option is located in the View tab (see right), 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 window to pop up, as shown on the right. This window gives you the option to select a set magnification (eg. 200%, 400%, etc.), or to specify a magnification of your own.

The window 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 or 2010, or the formatting toolbar in Excel 2003.

For example, in Excel 2007 and Excel 2010, you can return to the spreadsheet's original size, by a single click of the 100% zoom icon, or you can zoom to the current selected range of cells by a single click of the Zoom to Selection icon, both of which are provided on the ribbon (under the View tab).


Excel Zoom to Show Named Ranges

Excel Zoom to Display Named Ranges

If you zoom your Excel worksheet to less than 40%, Excel automatically displays all your named ranges, as shown in the image on the right.

This can be useful for helping you to keep track of the named ranges in your worksheet.


Excel Zoom Keyboard Shortcut

If, at any time, you want to quickly access the zoom window, you can simply press:

ALT-V Z

I.e. press the ALT key, and while keeping this depressed, press V and then Z.


Excel Zoom on Roll With IntelliMouse

Alternatively, if you have a mouse with a roller wheel, you can select 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:

In Excel 2010:

  • Select the File tab, and from this, select Options
  • The Zoom on roll with IntelliMouse option is found in the Advanced section of the Excel 2010 Options menu

In Excel 2007:

  • Select the main Excel menu (by selecting the Excel Logo on the top left of the spreadsheet), and from this, select Options
  • The Zoom on roll with IntelliMouse option is found in the Advanced section of the Excel 2007 Options menu

In Excel 2003:

  • Select Tools→Options..., to open up the Options window
  • The Zoom on roll with IntelliMouse option is found in the General tab of the Excel 2003 Options window
Return to the Basic Excel Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net