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?