Save Time in Microsoft Excel using Zoom Shortcuts

by Avantix Learning Team | Updated March 2, 2020

Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)

One common thing that many Excel users want to be able to do quickly is zoom in and out in their Excel worksheets. There are several shortcuts you can use to zoom in and zoom out quickly using a mouse or a keyboard.

Recommended article: No Mouse? Using Keyboard Only Navigation in Microsoft Office (Part 1: The Ribbon)

Check out the following strategies for zooming in and out using the mouse or your keyboard.

Zooming in and out using the mouse

If you have a mouse wheel in the middle of your mouse, press Ctrl while rolling the mouse wheel forward or backward to zoom in and out.

Zooming in and out using the keyboard (2016 and later versions)

If you have Excel 2016 or a later version, you can now zoom in and out by pressing Ctrl + Alt + plus sign (+) or Ctrl + Alt + minus sign (-).

Accessing the Zoom dialog using the keyboard

You can zoom in and out by accessing the Zoom dialog in the Ribbon using the keyboard:

  1. Press Alt . Key tip labels or badges appear on the Ribbon.
  2. Press w to activate the View tab.
  3. Press q to display the Zoom dialog box.
  4. Use the up and down arrow keys to select a zoom level. If you select Custom, enter a zoom percentage.
  5. Press Enter.

Microsoft Excel zoom dialog box to choose zoom levels.

Adding zoom buttons to the Quick Access Toolbar

You can also add zoom buttons to the Quick Access Toolbar and then use keyboard shortcuts to access them:

  1. Click the File tab in the Ribbon and then click Options.
  2. Click Quick Access Toolbar category on the left.
  3. From the drop-down menu under Choose commands from, select All Commands.
  4. Click the button(s) you wish to add. In this case, add Zoom (with the magnifying glass) and Zoom In and Zoom Out.
  5. Click Add. Repeat for each button.
  6. If you wish to re-order buttons, click the button in the Customize Quick Access toolbar pane on the right and click the Move Up or Move Down arrow buttons.
  7. Click Close.

MicrosoftExcelZoomButtonsAddingtoQAT

Once you have added the desired buttons, Excel assigns keyboard shortcuts automatically to the buttons based on the order in the Quick Access toolbar. For example, the first button can be accessed by pressing Alt and then 1, the second button by pressing Alt and then 2 and so on.

You can zoom in and out quickly and easily using these simple shortcuts in Excel.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

To request this page in an alternate format, contact us.

Recommended Microsoft Excel training

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to Visual Basic for Applications (VBA)

MORE COURSES >

Our instructor-led classroom training courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some courses may also be delivered at an alternate downtown Toronto location). Contact us if you’d like to arrange custom training at your office on a date that’s convenient for you.

To request this page in an alternate format, contact us.

 

Copyright 2020 Avantix® Learning 

You may also like

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Summary
Excel Shortcuts to Zoom In and Out in Your Worksheets (Mouse and Keyboard Shortcuts)
Article Name
Excel Shortcuts to Zoom In and Out in Your Worksheets (Mouse and Keyboard Shortcuts)
Description
One common thing that many Excel users want to be able to do quickly is zoom in and out in their Excel worksheets. There are several shortcuts you can use to zoom in and zoom out quickly using a mouse or a keyboard.
Author
Publisher Name
Avantix Learning Inc.

Pin It on Pinterest

Share This