This post will guide you how to zoom all sheet tabs at the same size quickly in excel. How do I zoom all sheet tabs with VBA code in excel. How can I change the zoom size of all sheet tabs in a workbook in excel.

Zoom All Sheet Tabs with Short keys

---

If you want to zoom all sheets in one certain size, you can use the Ctrl or Shift key to select those sheets firstly, then click zoom button to zoom them. Just see the below screenshot.

Zoom All sheet Tabs with VBA code

---

If you want to zoom all sheet tabs quickly, you can create an excel VBA Macro code to achieve it. Just do the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module

#4 paste the below VBA code into the code window. Then clicking “Save” button.

Sub ZoomAllSheets ()
    Dim I As Long
    Dim xActSheet As Worksheet
    Set xActSheet = ActiveSheet
    For I = 1 To ThisWorkbook.Sheets.Count
        Sheets(I).Activate
        ActiveWindow.Zoom = 120
    Next
    xActSheet.Select
End Sub

#5 back to the current worksheet, then run the above excel macro. Click Run button.

#6 Let’s see the result: