formating multiple worksheet via print preview

[Roger]

I have a multiple worksheet workbook that I need to change
several features about all the worksheets (page
orientation, fit to 1 page, etc.). How can I do this
formating and have it apply to all the worksheets selected
in the group rather than having to do it to each worksheet
separately? Thanks in advance.

Roger

 

[Andy B]

Roger

Group the worksheets you want to change. Change the relevant settings on one
of them and it will be reflected in the others. Don't forget to ungroup the
sheets afterwards.

Andy.

 

[Guest]

Andy,

That isn't working for me. It only applies to the one
worksheet. I can change contents of a cell and it is
changed in each of the worksheets in the group, but not
the formatting done in the setup method.

Roger

 

[Roger]

Andy's solution works if you select the worksheets as a
group and use File -> Page Setup and then make the
changes.

It does not work when using Print Preview -> Setup and
make the changes.

Roger

 

[Kevin Stecyk]

Roger,

I just tried grouping, and changing cell attributes (shading, italics, bold)
and page setup (landscape and print to one page). The formatting changes
were successfully applied to all pages in the group. I checked pages
outside the group, and they were unaffected. Thus, Andy's solution appears
to work for me.

I am using XL 2000.

Regards,
Kevin

 

[Andy B]

Roger

Sorry, I should have made this clear in my post.

Andy.