MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Duplex Printing


Posted by lenze on January 30, 2002 8:28 AM

If you have a print area on both sheet 1 and sheet 2, How do you get them to print in a duplex mode. Sheet 1 on the front and sheet 2 on the back? Duplex works fine when print areas are on same sheet and adjacent, but not when on separate sheets.

Thanks


Posted by Brian on February 05, 2002 4:12 AM

You should be able to do this by grouping all the printed sheets together (click each of them while holding down CTRL.

Then do a "File.Print" and select "Active worksheets"