I have a excel spreadsheet with two worksheets. I want to print both
worksheet on the same paper on both sides duplex. I know someone might
suggest that I print the first sheet then turn the paper over to print
the second sheet, but thats not what I want. I select both worksheets
choose the duplex option on the printer and print but the worksheet
always comes on two different sheets of paper. Any help would greatly
appreaciated. Thanks i advance..


--
jacksprat
------------------------------------------------------------------------
jacksprat's Profile: http://www.excelforum.com/member.php...o&userid=34916
View this thread: http://www.excelforum.com/showthread...hreadid=546528

I have a excel spreadsheet with two worksheets. I want to print both
worksheet on the same paper on both sides duplex. I know someone might
suggest that I print the first sheet then turn the paper over to print
the second sheet, but that's not what I want. I select both worksheets
choose the duplex option on the printer and print but the worksheet
always comes on two different sheets of paper. Any help would greatly
appreciated. Thanks in advance.

I’ve done it this way. It’s not elegant, admittedly.

Print the workbook to the “Microsoft Office Document Image Writer.” This
opens a “Microsoft Office Document Imaging” window for each worksheet.

Next, combine the worksheets into a single document. To do this, notice
that each of the “Imaging” windows has a left pane with thumbnails of the
page(s). Using right-click, “Copy” one or more thumbnails from the left
pane of one window and “Paste” it into the left pane of another. Repeating
this, the entire document can be merged into a single window. Finally,
print from that window.

Hope this helps.

If you do this sort of thing a lot, you might want to look into
http://fineprint.com/products/fineprint/index.html
for an add-on program that (among many other features) can combine several
print jobs into one, with fewer steps than using Image Writer.