worksheets

[Zoom on Sheets]

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

[LanceB]

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?

[Gord Dibben]

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

View>Zoom

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
Sheets@discussions.microsoft.com> wrote:

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