How Can I Apply Page Setup to Entire Workbook

  • Thread starter Thread starter evan
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Fit To Not Working 1
How do I fit to 1 page on entire workbook 2
Print a worksheet to a page 4
Spreadsheet resized when printed 3
Duplex Printing of Workbook with multiple worksheets 2
page setup 2
Printing Sheets in a Workbook 3
Fit To Pages & page Breaks 1

Back
Top