View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Barb[_3_] Barb[_3_] is offline
external usenet poster
 
Posts: 1
Default Can you print multiple worksheets double sided?

Here is how to get multiple worksheets in one workbook printed with
true double sided printing (to prevent each worksheet from starting a
new page):
* Open each worksheet that you are going to print individually
* Go to the File / Page Setup menu and click on the Print... button
(you are not going to print at this time, but you need to set each
of the worksheets to the double sided option)
* When the print window comes up, click on the Properties... button
* Under the 2 sided print, change the drop down menu to 2 sided
printing
* Click on the OK button
* This takes you back to the print window - DO NOT click on the OK
button (it will print the sheet) - instead click on the Close button

You have now reset that individual worksheet to double sided printing.
You need to do that for every other individual worksheet that you
intend to print from the workbook.

Then when you are ready to print, click on the first tab of the
worksheet you want to print.
Then hold down the control key (Ctrl) and click on each other
worksheet tab that you want to print
(they will all change from gray to white as you select them to show
you which ones you have picked)
Then go to the File / Print menu, make sure that under "Print What"
the button for Active Sheets is selected.
Then go to the Properties... button and make sure that it is set for
double sided printing.
Then print a copy.

Hopefully you will now have a true double sided copy of the multiple
worksheets in your Excel workbook without each tab starting a new
page.

One note of caution...
When you have multiple worksheets selected in this manner, if you make
changes to the page setup (margins, etc.) the changes will be applied
to every once of the worksheets that are in the selected group. It is
easy to forget that they are all selected and to change what you think
is just the worksheet that is showing, and mistakenly change all of
the others. Also, if you save with multiple worksheets selected, when
you open the workbook again, they will still be selected. Learned
this one the hard way... :-(

Barb