the simplest way is to make sure that each sheet will print an even number of
sheets.
Check print preview and add lines or page breaks when needed.

"Sam Vanderstraeten" wrote:

Hi all,

I have the following problem in Excel 2003...
I have an Excel document with multiple worksheets. Every worksheet contains
one or more (!) pages when printing them. Now I want to print those pages
recto/verso.
The problem is that pages of the different worksheets may NOT be printed at
the back-side of the last page of the previous worksheet.
For example:
Worksheet A has 2 pages when printing
Worksheet B has 3 pages when printing
Worksheet C has 2 pages when printing

When I now print the whole file recto/verso;
-- Worksheet A will be OK
-- Page 1 & 2 of Worksheet B, will be OK
-- Page 3 of Worksheet B AND page 1 of worksheet C will be on the same
paper
-- page 2 of Worksheet C will be on one paper...

How can I solve this problem that no pages of a worksheet is printed on a
page of another worksheet?

In my example, I should get:
-- Page 1 & 2 of Worksheet A on one page
-- Page 1 & 2 of Worksheet B on one page
-- Page 3 of Worksheet B on one page, with a blank back!!
-- Page 1 & 2 of Worksheet C on one page

Thanks in advance!

Sam