worksheets
 

How do I change the "zoom" on all the excel sheets at one time?

worksheets
 

Manually?

You can hold the shift key down or the ctrl key down and select all sheets.
Setting the zoom then shanges all sheets. As a note with all sheets
selected changes to one sheet are made to all sheets. Save your work beforre
trying this.


"Zoom on Sheets" wrote:

How do I change the "zoom" on all the excel sheets at one time?

worksheets
 

Right-click on a sheet tab and "Select all sheets".

ViewZoom

Will be set on all sheets.

Right-click and "Ungroup sheets" when done.

To slect non-contiguous sheets, CTRL + Click on tabs.


Gord Dibben MS Excel MVP

On Thu, 13 Jul 2006 08:35:02 -0700, Zoom on Sheets <Zoom on
wrote:

How do I change the "zoom" on all the excel sheets at one time?