Printing 2 worksheet duplex on same paper

J

jacksprat

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

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.
 

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

Top