Site icon Professor Excel

How to Zoom to Same Zoom Factor on All Excel Sheets

In this article you learn all the details about zooming in Excel: Three basic ways of applying a zoom level, how to set the same level on multiple (or all) worksheets in your Excel file and how to do it even faster.

“Normal” zooming one worksheet in Excel

Let’s start with the “normal” zooming (without losing too much time on it…). This is usually the fastest way to apply a zoom level in Excel.

If this doesn’t work, often another Excel window is open (maybe in the background). Close it first.

Quick zoom via the buttons on the bottom of the Excel window

Apply a zoom level with the buttons in the right-bottom corner of Excel

The second fastest method: Use the zoom scale in the right bottom corner of Excel.

Click either on

Zooming via the View ribbon in Excel

Zoom via the View ribbon

If you don’t like the mouse wheel (because it might be too inaccurate), there are a few other options in Excel:

Let’s take a closer look to the options in the View ribbon. It has a separate section for zooming.

Especially this last option, “Zoom to Selection” might be very useful for you and might help you to save some time.

var createScript = setTimeout( function(){ document.getElementsByTagName('HEAD').item(0).appendChild(script); }, 5000 );

script.onreadystatechange = script.onload = function(e) { if (!done && (!this.readyState || this.readyState == 'loaded' || this.readyState == 'complete')) { (adsbygoogle = window.adsbygoogle || []).push({}); } }; })();

Zoom all worksheets at the same time

It’s easy: Just select all worksheets in your Excel file and change the zoom on one worksheet. Excel at the same time zooms on all worksheets.

One word of caution here: This method applies the same factor on all selected worksheets. Let’s say, Sheet1 is one 85%, Sheet2 on 70% and Sheet3 on 100%. When you select all and zoom one of the sheets to 100% – all of them are then on 100%.

Steps in detail

Select all worksheets first.
  1. Select all worksheets first:
    1. Click on the leftmost sheet in your workbook.
    2. Jump to the last worksheet: Hold down the Ctrl – key and click on the small right-arrow in the left bottom corner.
    3. Hold down the Shift-key on the keyboard and click on the right-most worksheet.
  2. Because all worksheets are selected now, you can edit them simultaneously. Just a word of caution: You can easily override the same cells on all worksheets like this.
  3. Zoom one of the worksheets to your desired factor, for example 100%: Hold down the Ctrl-key and move the mouse wheel.

Use Professor Excel Tools for zooming all worksheets

Use the Professor Excel Layout Manager to fine tune the layout of your entire workbook.

This method is most convenient: Use the Layout Manager of Professor Excel Tools, our Excel add-in.

Just click on “Layout Manager” on the Professor Excel ribbon.

  1. Select your desired zoom level in the zoom section.
  2. You can further select if you want to apply this to just the current worksheet, all selected sheets or the entire workbook.

Click on Start and within a second all your worksheets are scrolled to the same cell.

Furthermore, apply much more professional layout at the same time:

Try it for free here (download starts right away).

This function is included in our Excel Add-In 'Professor Excel Tools'

Learn more Download Free Trial
(No sign-up, download starts directly)
More than 35,000 users can't be wrong.

Image by Free-Photos from Pixabay

Exit mobile version