How to Zoom In or Out in Excel (6 Possible Ways)

In this article, you will learn how to perform zooming in and out in Excel using the keyboard shortcuts, the zoom slider, and the view tab. Moreover, there will be an easy VBA code to increment the zoom level by a specific margin.

When we need to view a large amount of data or if our display screen is not large enough to view a set of data, we need to zoom out in Excel.

Similarly, when the dataset is small or we need to work in detail, we need to zoom in in Excel for better visualization.

Zooming Slider in Excel

Use Zoom Slider
Apply a Combination of Keyboard and Mouse Wheel
Apply Keyboard Shortcut
Utilize View Tab
Use Workbook Views
Apply VBA Code
Things to Remember
Zooming in Excel: Knowledge Hub

1. Use Zoom Slider to Zoom In or Out in Excel

  • You can drag the zoom slider to the left to zoom out and to the right to zoom in.
  • Alternatively, you may click on the Minus sign to zoom out and Plus sign to zoom in.

Zooming Slider to Zoom Out in Excel

  • Moreover, you can click on the zoom level percentage value.
  • Type a custom value to set a zoom level according to your needs.

Custom Zooming Slider in Excel

  • This is the output of setting the zoom level to 88%.

Output of Custom Zooming Slider

2. Apply Combination of Keyboard and Mouse Wheel

  • To zoom in, hold down the Ctrl key and scroll the mouse wheel upward.
  • Similarly, to zoom out, hold down the Ctrl key and scroll the mouse wheel downward.
Using Combination of Keyboard and Mouse Wheel for Zooming in Excel

Click the GIF for a detailed view

3. Apply Keyboard Shortcut

  • Press Ctrl+Shift+Plus to zoom in.
  • Ctrl+Shift+Minus to zoom out.

Keyboard Shortcut to Change Excel Zooming

4. Utilize View Tab to Zoom In or Out

  • There are three options in the View tab under the Zoom group.
  • Select Zoom to use custom zoom.
  • Choose 100% to zoom the document to 100%.
  • Zoom to Selection to zoom in on a particular selection in the sheet.

Zoom Group Under Excel View Tab

5. Use Workbook Views

  • There are four views available under the Workbook Views group.

Workbook Views Under View Tab

  • Select the Page Break Preview; it will zoom out the Excel file.

Page Break View

  • The Page Layout view will split the sheet into several pages.

Page Layout View for Excel Zooming

  • Lastly, select Normal, and it will zoom out again.

Normal View to Zoom Out

6. Apply VBA to Excel Zooming In or Out

We can use VBA to zoom in or zoom out the active Excel window as well. Apply the following steps to zoom in or zoom out using Excel.

  • Consider the following image. The current zoom level is 80% for the active window. Now, go to the Developer tab and click the Visual Basic option to open the Visual Basic Editor window.

Visual Basic Option in Developer Tab

Note: You can use Alt + F11 to quickly open the Visual Basic Editor window.

  • In the Visual Basic Editor window, click the Insert tab and select the Module option.

Inserting Module

  • Enter the following code in the module. Here, we have two subroutines. The ZoomInActiveWindow subroutine zooms into the active Excel window and The ZoomOutActiveWindow subroutine zooms out the active Excel window.
  • Click the Save and Run button.

VBA Code to Zoom in or Out Excel Window


Sub ZoomInActiveWindow()
    On Error Resume Next
    increase_zoom = InputBox("Increase zoom level by:")
    If IsNumeric(increase_zoom) = False Then
        MsgBox "Enter a number please!"
        Exit Sub
    End If
    ActiveWindow.Zoom = ActiveWindow.Zoom + increase_zoom
End Sub

Sub ZoomOutActiveWindow()
    On Error Resume Next
    decrease_zoom = InputBox("Decrease zoom level by:")
    If IsNumeric(decrease_zoom) = False Then
        MsgBox "Enter a number please!"
        Exit Sub
    End If
    ActiveWindow.Zoom = ActiveWindow.Zoom - decrease_zoom
End Sub

  • After clicking the Run button, you will get a dialog box with both the subroutines. If you want to zoom in, then select the ZoomInActiveWindow subroutine, and if you want to zoom out, then select the ZoomOutActiveWindow subroutine. Here, I have selected the ZoomInActiveWindow subroutine.
  • Then, click the Run button.

Running VBA Subroutine to Zoom in Excel

  • After clicking the Run button, you will get an input box. Enter a number to increase the zoom level. Here, I have entered the value 7.
  • Then, click the OK button.

Entering Zoom Level Increase Value

  • Since the previous zoom level was 80%, the current zoom level will be increased to 87% after clicking the OK button. Similarly, you can zoom out your Excel window by running the ZoomOutActiveWindow subroutine.

Zoom Level Increased

What Are the Things to Remember?

  • If you zoom in or out on a worksheet, then it will change only that worksheet. Other worksheets or opened files will not change.
  • You can zoom in or out in multiple worksheets, for that, you need to select all the sheets first and then do the zoom operation.
  • You can’t zoom in less than 10% and more than 400%.
  • If you have Named Range in your file, and zoom below 40%, it will show the name of the named range.

Download Practice Workbook


This ends our article on zooming in Excel. We have shown various ways to zoom in or zoom out and various features of zooming in Excel. If you have any questions or suggestions about this, please feel free to comment below.

Zooming in Excel: Knowledge Hub

<<Go Back to Excel Worksheets | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF