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: