Quickly Zoom All Worksheets to One Size in Microsoft Excel

Adjusting the zoom level on every individual sheet in an Excel workbook can be tedious. Thankfully, Excel allows you to apply a zoom level to all worksheets at once. Here's how:

Step 1: Select All Worksheets

First, click on any sheet tab to make it active. Then right-click and select Select All Sheets from the context menu.

Step 2: Adjust the Zoom Level

With all worksheets selected, go to the View tab on the ribbon, click Zoom in the Zoom group, and choose your preferred percentage.

Alternatively, you can use the Zoom Slider at the bottom-right corner of the Excel window to adjust the zoom level.

Step 3: Deselect All Worksheets

Once you've adjusted the zoom, right-click on any of the selected sheet tabs and click on Ungroup Sheets. This will deselect the sheets, allowing you to work on individual sheets again.

Note that when all worksheets are grouped, changes you make to one sheet will be applied to all sheets. Always remember to ungroup your sheets once you're done.