How to Zoom In or Out in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on August 25, 2023

This tutorial demonstrates how to zoom in or out in Excel and Google Sheets.


zoom in out 3


Zoom In or Out With Mouse

To zoom in or out with your mouse, just press CTRL and roll the mouse wheel forward or backward to zoom in or zoom out, respectively.


mouse wheel updown


Zoom Dialog

You can easily zoom in or out in Excel using the Zoom dialog box.

  1. In the Ribbon, go to View > Zoom.


zoom in out 4


  1. The Zoom dialog box opens. In it, you can choose one of the existing options or choose Custom and enter a specific zoom percentage.


zoom in out 5


Zoom to Selected Range

In Excel, you can zoom the sheet so that the selected range of cells fills the entire window. This feature can be helpful if you want to focus on a specific area of the sheet.

  1. First, select the range you want to focus on.
  2. Then in the Ribbon go to View.
  3. Click Zoom to Selection.


zoom in out 7


As a result, the selected range fills the window.


zoom in out 8


Zoom Sheet to 100%

  1. To quickly zoom your document to 100%, in the Ribbon, go to View.
  2. Press 100% in the Zoom group.


zoom in out 6


This shows the worksheet at its print size.

Open Zoom Dialog Using Keyboard

To zoom in or out you can access the Zoom dialog box using the keyboard.

  1. Press ALT to display key tip labels on the Ribbon. To activate the View tab, press W.


zoom in out 12


  1. Then type Q to open the Zoom dialog box.
    (So, ALT > W > Q.)


zoom in out 13


  1. Choose the magnification you want in the Zoom window.


zoom in out 14


Add Zoom In and Out Buttons to Quick Access Toolbar

To quickly access the zoom in and out buttons you can add them to the quick access toolbar.

In the Ribbon, go to File > Options. to open the Excel Options window.


zoom in out 9


  1. In the left-side menu, choose Quick Access Toolbar.
  2. Select All Commands from the Choose commands from drop down.
  3. Scroll in the box below until you find Zoom In and Zoom Out.
  4. Press Add.
  5. Click OK.


zoom in out 10


As a result, Zoom In and Zoom Out buttons are added to the quick access toolbar.


zoom in out 11


Zoom In or Out in Google Sheets

Built-in Zoom Functionality

In Google Sheets, you can quickly zoom in or zoom out with built-in zoom functionality.

  1. Click on the zoom option in the Toolbar.
  2. From the drop down, choose one of the preset options.


zoom in out 15


Zoom In or Out: Toolbar

Another way to zoom in or out in Google Sheets is to go through the Toolbar.

  1. Click View.
  2. From the list, choose Zoom.
  3. Select a magnification value.


zoom in out 16


Zoom In or Out: Mouse

You can also use the mouse to zoom in or out, just press CTRL and roll the mouse wheel forward or backward to zoom in or zoom out. (This is exactly the same in Excel.)

Zoom In or Out With Shortcut

To zoom in with a shortcut, press CTRL + + (plus sign) on the numeric keypad and to zoom out press CTRL + – (minus sign). It wont work if you use the + or – typing (alphanumeric) keys.

AI Formula Generator

Try for Free

See all How-To Articles