Printing the Workbook

[Richard]

Hi. I'm using Excel 97. I've got 6 sheets. All sheets prints one page exept
one sheet that prints two pages, so there are 7 pages to print. My printer
is set to print automatic duplex. This is what I am seeking to get:

Sheet Name Paper Side of Paper
No.

Funds 1 Front
Bank 1 Back
Petty Cash 2 Front
2 Back
Expenditure 3 Front
Equipment 3 Back
Balances 4 Front
4 Back (Blank)

But I get the following:

Funds 1 Front
Bank 1 Back
Petty Cash 2 Front
2 Back
Expenditure 3 Front
3 Back (Blank)
Equipment 4 Front
4 Back (Blank)
Balances 5 Front
5 Back (Blank)

I do not understand why, starting with the Expenditure sheet, I'm not
getting a duplex result. The Equipment sheet ought to be printing on the
back of paper number 3. Expenditure, Equipment and Balances sheets do show
only one page to print when I do a Print Preview. Any ideas? TIA.

 

[Jerry]

You may need to set the print range or reduce the size of the pages to fit
to one page.