You can change the %zoom on a group by simply grouping the worksheets to
start with and then applying the zoom factor, though don't forget to ungroup
them after.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Carol" wrote in message
...
I would like to see the following 2 improvements for grouped worksheets:

Enable print area setting for a group of worksheets - I have 100
identicallyy formatted sheets, and to make this change to each is
cumbersome.

Enable % size change for viewing for a group of worksheets - make sure it
works on numbers different from your standard = 60%, 85%, 40% etc.... I
have
100 identicallyy formatted sheets, and to make this change to each is
cumbersome.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions