Printing separate sheets on one paper sheet

[Attyla]

Hey,
I'd like to print two different excel sheets on both sides of a paper
sheet (one excel sheet on one paper side). I've configured the sheets
in excel to be exactly one page sized, and when I send them to the
printer (with the "print on both sides" option checked) it still
prints the sheets on separate paper sheets.

How do I solve this ?

Attyla

 

[Dave Peterson]

Maybe you could put the both ranges on a temporary worksheet and print from
there.

You could copy the ranges and paste as pictures, so they'll always reflect the
most current data.

Select a range
edit|copy
select A1 on that helper worksheet
Shift-Edit|Paste Picture Link

Paste the picture for the second range under the first picture.

(Put a page break between them if required.)


Another option:
Print one, turn the sheet over and refeed it into the printer and print the
second.

 

[Jay]

I'd like to print two different excel sheets on both sides of a paper

sheet (one excel sheet on one paper side). I've configured the sheets
in excel to be exactly one page sized, and when I send them to the
printer (with the "print on both sides" option checked) it still
prints the sheets on separate paper sheets.

If you're open to getting extra software for this need, you might consider
FinePrint:
http://fineprint.com/products/fineprint/index.html
I use this software for a variety of things. Among its features is
combining several print jobs into one.