How Can I Apply Page Setup to Entire Workbook

E

evan

Say I have an excel workbook set up with 100 worksheets. Now I want t
go print it. Is there a way to globally set the page setup parameter
for every page, or do I have to go into page setup 100 times?

For example, I want the entire workbook to print out with eac
worksheet "fit to 1 page wide by 1 page tall".

Thanks
 
A

Andy B

Hi

Group your sheets together (right click on one tab and select 'Select all
sheets' and use File / Page Setup to set them all at once. Don't forget to
ungroup your sheets afterwards.
 
E

evan

Thank You SOOO much! I can't tell you how much work you've saved me
Gee, wish I came to this forum a long time ago - this was going to b
the 3rd time I had to go into each sheet individually in 30+ pag
workbooks. I knew there had to be a better way.

Thanks again
 
Top