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 Inc.

You may also like

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

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