Converting worksheet into a different page size

  • Thread starter Thread starter epicman
  • Start date Start date
E

epicman

I have some workbooks that contain multiple worksheets. Is it possible
to collectively change the size of the page that they will print out on
once i select, File --> Print --> Entire Workbook --> OK.

Normally what happens is that I have to do page setup of each
individual worksheet before I can get the entire work book to print on
the desired page size. If anyone out there can help make this process
simpler (eg a single click) then please let me know.


Thanks.
 
You can group the worksheets in the workbook and then set the page size for
all the selected worksheets. You can click on the first sheet tab and then
Shift + Click on the last worksheet tab to select a contiguous group of
worksheets, or you can Ctrl + Click on each worksheet tab that you want to
print to select a non-contiguous group of worksheets
 

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

Workbook Printing Problem 1
Print worksheet 2 on back of worksheet 1, etc.... 1
Duplex Printing of Workbook with multiple worksheets 2
Printing multiple worksheets in a workbook 3
Printing Sheets in a Workbook 3
Printing Worksheet/Workbook 2
Footer - Page Number problem 3
Print selected worksheets in multiple workbooks? 1

Back
Top