View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Duplex Printing of Workbook with multiple worksheets

Manually? Print 6 worksheets, flip them back over into the paper tray,
print the other 6 worksheets

Lenny wrote:

I have a workbook with 12 worksheets... I want to print the worksheets out
consecutively back to back. The contents of each worksheet is only 1 page
each when printed out.

When I select print Entire Workbook and print preview... the preview shows
the pages continuous in the preview. But, when it prints, it prints each
worksheet out as a single sided page....I have played around with the
settings and cannot seem to get it to print the entire contents of the
workbook doublesided. Can it even be accomplished?

Lenny