If you want to set the same zoom level for several worksheets in a workbook, you can do this all at once by first grouping the worksheets together. If the worksheets you want are all next to each other in the workbook, from the first worksheet tab to be included, hold down the Shift key and click on the last worksheet tab to be included. If the worksheets are not next to each other in the workbook, hold down the Ctrl key whilst clicking on the worksheet tabs to be included. Now go to the Zoom slider at the bottom right of the window and either use the slider to get to the required zoom level, or click on the + and – signs at the right and left of the slider to change the zoom level in increments of 10%. Alternatively, click on the number showing the percent to open up the Zoom dialog box to make a specific selection there.
Your chosen zoom level will be applied to all the grouped worksheets. To ungroup the worksheets to work on them separately, right-click on any of the worksheet tabs and select Ungroup Sheets.
Find out more about our Excel training courses Sydney, Australia.