Forum Discussion
Excel 2016 Workbook Printing Double Sided problem
If you’re trying to print off an entire Excel workbook (all the tabs, or more than one tab) you’re likely to have trouble getting it to duplex print properly.
The reason for this is that Excel is inclined to treat each of those tabs as a separate document, each with its own printer settings (I know this is an oversimplification, but thinking of it this way makes the problem easier to understand).
The simple fix it is to go to each individual tab and adjust the print settings (IE: from each tab, go to File --> Print, and select duplex).
You can also do this from the “Print” settings page by scrolling through the print previewed document for the entire workbook, and adjusting the settings as you get to any given page from each tab.
Your idea worked, but it's annoying to have to open the print dialog separately for each worksheet. Do you know how I automate this process? Scruffy