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.
Ajames01 I don't know if this applies to your situation, but I have found that you can only duplex b/w with b/w & color w/color - you can't duplex with b/w on one side & color on the other.
- Try the first method listed here:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/set-page-setup-attributes
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
Scruffy this absolutely solved my problem. Thank you! I can't tell you how many hours I've spent on trying to figure this out!
