How to print every pages double sided in excel?

[Legacy 386498]

Hi,

For now, I go to print, select entire workbook, choose double sided, next page, rinse and repeat. The problem is I have 50 pages to do, is there a way to print the entire workbook double sided automatically?

Thanks.

 

[ChrisFoster]

In the print settings you should be able to change it from 'Print Active Sheets' to 'Print Entire Workbook'.

 

[Legacy 386498]

Yeah, that's what I already did: "For now, I go to print, select entire workbook". But I still need to change every page one by one to double sided (or I'm doing something wrong).

 

[Eric W]

The duplex mode is set at the printer, not at Excel. Click Print, then under Printer you should see a hyperlink saying "Printer Properties". Click on that and look for something like "Print on both sides".

 

[Legacy 386498]

Yeah, I tried that too, but it didn't work. I thought maybe the option of one sided in excel had "priority" over the printer.

 

[ChrisFoster]

It sounds to me like it's a setting on the actual printer that is causing it rather than excel.