Save Time in Microsoft Excel using Zoom Shortcuts

by Avantix Learning Team | Updated July 12, 2017

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

One common thing that many Excel users want to be able to do quickly is zoom in and out in their Excel workbooks. This is helpful for users with varying levels of vision impairment

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.

Zoom in and out using the mouse

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

Zoom in and out using the keyboard (2016 users only)

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

Access 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 the Alt key. 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.

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

Copyright 2017 Avantix Learning Inc.

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 2019 Avantix® Learning Inc.

You may also like

How to Create 3D References in Microsoft Excel

You can use 3D references in Excel formulas to calculate across multiple worksheets that are structured in the same way. A 3D reference refers to the same cell or range of cells on multiple worksheets.

How to Freeze Row and Column Headings in Microsoft Excel

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

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

Pin It on Pinterest

Share This