change all the worksheets' printing preference in one go

[mingali]

Hi,

I selected all worksheets and changed the printing preference from printing one side to both sides. However, one side printing still being used. I found that i need to change the printing preference for each worksheet. It seems select all worksheets for changing printing perference not working.

Is there any quick way of changing the printing preference for all worksheets?

Thanks

[enwoznick]

The only way I have ever been able to do this is to print the entire workbook to a PDF and then adjust the print settings for the PDF. Would love to know if anyone has a different way!