Front and Back Printing in Excel

[CBFISH]

Assuming the printer has the ability to print front and back, is there a way to have "Sheet1" print on the front side and "Sheet2" print on the back? I can do it easily if they are all on the same sheet, but when I try to print two separate sheets front and back it just prints them on two separate pieces of paper.

Thanks for the help!

 

[TonyJollans]

Hi CBFISH,

Your printer will not print two separate 'jobs' on the same piece of paper, so you need to do it all in one job. If you want to print two complete sheets, then simply select them both and press Print. If you want to make selections from the sheets and/or use different zoom levels it may prove more difficult.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[