Is there a way to set every tab in a excel workbook to share the exact same print properties
Posted on 2008-10-09
Is there a way to set every tab in a excel workbook to share the exact same print properties.
I have an excel file that has multiple tabs. I want to print the entire workbook using double sided printing.
When I tell Excel to print entire workbook and set the print properties to do double sided printing, it will print the first tab double sidded and every tab after that on one side. The way Excel works is you would have to go under every single tab and set the page setup to do double sided printing then print the entire workbook. What if you have 50 tabs can't I set up properties once for the entire workbook?