Microsoft Excel – setting same zoom level for several worksheets

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.

Find out more about our Excel training courses London, Surrey, Middlesex UK, or our Excel training courses Wiltshire, Dorset, Hampshire.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s