Printing 2 worksheet duplex on same paper

[jacksprat]

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..

[MyVeryOwnSelf]

> 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.