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.



Attyla wrote:

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