Zoom in Excel: Change Your Worksheet Magnification

Today's meeting has finance in focus
PeopleImages / Getty Images

The zoom feature in Excel changes the scale of a worksheet on screen, allowing users to enlarge specific areas by zooming in or zooming out in order to see entire worksheets all at once.

Adjusting the zoom level does not affect the actual size of a worksheet, so printouts of the current sheet remain the same, regardless of the selected zoom level.

In the latest versions of Excel, zooming in on a worksheet can be accomplished using one of three methods different methods:

Zoom Slider

Changing the magnification of a worksheet using the zoom slider is accomplished by dragging the slider box back and forth.

Screenshot of Excel showing the zoom slider

Dragging the slider box to the right zooms in; thus less of the worksheet is seen and the size of objects, such as cells, row and column headers, and data increases, in the spreadsheet.

Dragging the slider box to the left zooms out; thus it has the opposite results — the amount of the worksheet seen increases and objects in the worksheet decrease in size.

An alternative to using the slider box is to select the Zoom Out and Zoom In buttons located at either end of the slider. The buttons zoom the worksheet in or out in increments of 10%.

Zoom Option

On the View tab, the Zoom section of the ribbon contains three options for quickly adjusting your view of the spreadsheet: Zoom, 100%, and Zoom to Selection.

Screenshot of Excel showing zoom options on the ribbon

Selecting the Zoom option on the View tab of the ribbon opens the Zoom dialog; this dialog box contains pre-set magnification options ranging from 25% to 200%, as well as choices for custom magnification and zooming to fit the current selection.

Zooming With Shortcut Keys

Keyboard key combinations that can be used for zooming in and out of a worksheet involve using the ALT key. These shortcuts access the zoom options on the View tab of the ribbon using keyboard keys rather than the mouse.

For the shortcuts listed below, press and release the keys listed in the correct order.

  • ALT + W + J: Activates the 100% zoom option on the ribbon.
  • ALT + W + G: Activates Zoom to Selection on the ribbon.
  • ALT + V + Z: Opens the Zoom dialog box.
  • ALT + W + Q: Opens the Zoom dialog box.

Once the Zoom dialog box is open, pressing one of the keys below followed by the Enter key will change the magnification level.

  • 0 + Enter: 200% zoom
  • 1 + Enter: 100% zoom
  • 7 + Enter: 75% zoom
  • 5 + Enter: 50% zoom
  • 2 + Enter: 25% zoom

Custom Zoom

Using the above keyboard keys to activate the Custom zoom option requires additional keystrokes in addition to those needed to open the Zoom dialog box.

After typing ALT + W + Q + C, enter numbers such as 33 for a 33% magnification level. Complete the sequence by pressing the Enter key.

Zoom on Roll With IntelliMouse

If you frequently adjust the zoom level of worksheets, you might want to use the Zoom on roll with IntelliMouse option.

Screenshot of Excel showing IntelliMouse option

When activated, this option allows you to zoom in or out using the scroll wheel; the option is activated using the Excel Options dialog box.

  1. Select the File menu option at the top of your screen.

  2. Select Options in the menu to open the Excel Options dialog box.

  3. Select Advanced in the left-hand panel of the dialog box.

  4. Select Zoom on roll with IntelliMouse in the right panel to activate this option.

Zoom Out to Display Named Ranges

If a worksheet contains one or more named ranges, zoom levels below 40% will display these named ranges surrounded by a border, providing a quick and easy way check of their location in a worksheet.