Excel Dual Sided Printing Question

[Ray1127]

I have an Excel 2003 Workbook with 4 worksheets. All 4 worksheets have the same data elements for 4 different people. Everytime I try to print the worksheet I specify to use both sides of the paper so I should get 4 pages each worksheet prints 2 pages. The first 2 worksheets do exactly that the next 2 each print single sided both pages print it just uses 2 sheets of papter instead of 1. I can't figure out what's different between the first 2 worksheets with print correctly and the next 2 which don't.

 

[lionelhill]

Possibly a minor misunderstanding between you and Excel. Have you tried visiting each worksheet in turn, and in print-preview, specify explicitly "fit to one page"?

 

[Ray1127]

No I don't want it to print to one page I want it to print on both sides of the paper. But also haven't gone to each sheet as yet. I'll try that.

 

[Ray1127]

Yep that worked. Apparently selecting print options for the entire workbook do not automatically apply to each worksheet. Don't get that but ok.