Home

Excel 2016 Workbook Printing Double Sided problem

%3CLINGO-SUB%20id%3D%22lingo-sub-140062%22%20slang%3D%22en-US%22%3EExcel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140062%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20a%20new%20Windows%2010%20computer.%26nbsp%3B%20Previously%2C%20I%20have%20used%20Excel%202016%20with%20no%20issues.%26nbsp%3B%20What%20I%20need%20to%20do%20is%20print%20a%20workbook%20in%20Excel%20(multiple%20worksheets)%20double%20sided.%26nbsp%3B%20For%20example%2C%20sheets%201-3%20are%20on%20one%20tab%2C%20while%20sheet%204%20is%20on%20another.%26nbsp%3B%20When%20I%20print%2C%20I%20would%20generally%20click%2C%20%22print%20entire%20workbook%22%20which%20then%20takes%20my%20document%20from%203%20pages%20to%204.%26nbsp%3B%20Pages%20one%20and%20two%20print%20double%20sided%20no%20problem%2C%20but%20no%20matter%20what%20I%20do%2C%20pages%203%20%26amp%3B%204%20will%20not%20print%20duplex.%26nbsp%3B%20Other%20than%20printing%20to%20pdf%20(which%20saves%20it%2C%20then%20I%20have%20to%20open%20that%20document%20and%20print%20from%20there%20which%20is%20a%20PAIN)%2C%20can%20I%20print%20those%204%20pages%20onto%202%2C%20or%20am%20I%20stuck%3F%20I%20have%20searched%20the%20internet%20to%20no%20avail.%26nbsp%3B%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-140062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharing%20%26amp%3B%20Publishing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698506%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F105089%22%20target%3D%22_blank%22%3E%40Adrienne%20Schroder%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20trying%20to%20print%20off%20an%20entire%20Excel%20workbook%20(all%20the%20tabs%2C%20or%20more%20than%20one%20tab)%20you%E2%80%99re%20likely%20to%20have%20trouble%20getting%20it%20to%20duplex%20print%20properly.%3C%2FP%3E%3CP%3EThe%20reason%20for%20this%20is%20that%20Excel%20is%20inclined%20to%20treat%20each%20of%20those%20tabs%20as%20a%20separate%20document%2C%20each%20with%20its%20own%20printer%20settings%20(I%20know%20this%20is%20an%20oversimplification%2C%20but%20thinking%20of%20it%20this%20way%20makes%20the%20problem%20easier%20to%20understand).%3C%2FP%3E%3CP%3EThe%20simple%20fix%20it%20is%20to%20go%20to%20each%20individual%20tab%20and%20adjust%20the%20print%20settings%20(IE%3A%20from%20each%20tab%2C%20go%20to%20File%20--%26gt%3B%20Print%2C%20and%20select%20duplex).%3C%2FP%3E%3CP%3EYou%20can%20also%20do%20this%20from%20the%20%E2%80%9CPrint%E2%80%9D%20settings%20page%20by%20scrolling%20through%20the%20print%20previewed%20document%20for%20the%20entire%20workbook%2C%20and%20adjusting%20the%20settings%20as%20you%20get%20to%20any%20given%20page%20from%20each%20tab.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307835%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307835%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20searching%20the%20net%20for%20a%20resolution%20to%20the%20excel%20not%20duplexing%20I%20read%20this%20post.%20I%20loaded%20my%20simple%20sheet%20into%20Libre%20Office%20and%20it%20will%20also%20not%20print%20multiple%20copies%20of%20the%20sheet%20by%20duplex.%20I%20printed%20the%20sheet%20to%20a%20pdf%20and%20Acrobat%20will%20not%20print%20it%20in%20duplex%20mode.%20It%20is%20my%20conjecture%20that%20the%20problem%20is%20in-coded%20in%20the%20sheet%20itself.%20Libre%20Office%20and%20Acrobat%20have%20not%20problem%20printing%20other%20documents%20and%20duplexing.%20I%20have%20put%20all%20the%20time%20I%20am%20going%20to%20into%20this%20issue%2C%20it's%20much%20faster%20for%20me%20to%20just%20duplex%20it%20manually.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-207710%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207710%22%20slang%3D%22en-US%22%3EHaving%20the%20same%20problem%20with%20Excel%202016%20not%20printing%20on%20both%20sides%20of%20paper%2C%20No%20matter%20what%20it%20prints%20single%20pages.%20Strange%20that%20no%20problem%20with%20Word%20documents%3F%20Also%2C%20PDF%20docs%20are%20fine%20also.%20Just%20the%20EXCEL%20files.%20Didn't%20have%20any%20problems%20until%20after%20some%20update%20was%20automatically%20downloaded%20with%20the%20365%20added.%20I%20uninstalled%20the%20365%20since%20I%20didn't%20want%20it.%20Also%20uninstalled%20EXCEL%202016%20as%20suggested%20from%20some%20tech%20at%20MS%20support.%20Re%20installed%20and%20it%20didn't%20have%20and%20effect.%20Very%20frustrated%2C%20MS%20has%20been%20of%20little%20to%20no%20help%20with%20this!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170702%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EWe%20are%20having%20the%20same%20problem.%20Did%20you%20get%20a%20solution%20to%20your%20issue%3F%3C%2FP%3E%0A%3CP%3EI%20can%20recreate%20this%20with%20Excel%202016%20both%20with%20and%20without%20O365%20but%20Office%202010's%20Excel%20will%20print%20double-sided%20and%20in%20colour%20no%20problem.%3C%2FP%3E%0A%3CP%3EAll%20updates%20applied%20and%20so%20far%20I%20haven't%20found%20a%20solution%20online.%20Still%20looking%20though...%3C%2FP%3E%0A%3CP%3Echeers%2C%3C%2FP%3E%0A%3CP%3EColleen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-140077%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Adrienne%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%2C%20did%20you%20check%20your%20default%20page%20size%20is%20the%20same%20on%20old%20and%20new%20PC%3As%2C%20(was%20A4%20and%20now%20A4)%20or%20changes%20(e.g.%20was%20A4%2C%20become%20Letter)%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20that's%20an%20Excel%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886077%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Workbook%20Printing%20Double%20Sided%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361816%22%20target%3D%22_blank%22%3E%40Scruffy%3C%2FA%3E%26nbsp%3B%20this%20absolutely%20solved%20my%20problem.%26nbsp%3B%20Thank%20you!%26nbsp%3B%20I%20can't%20tell%20you%20how%20many%20hours%20I've%20spent%20on%20trying%20to%20figure%20this%20out!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Adrienne Schroder
Occasional Visitor

I got a new Windows 10 computer.  Previously, I have used Excel 2016 with no issues.  What I need to do is print a workbook in Excel (multiple worksheets) double sided.  For example, sheets 1-3 are on one tab, while sheet 4 is on another.  When I print, I would generally click, "print entire workbook" which then takes my document from 3 pages to 4.  Pages one and two print double sided no problem, but no matter what I do, pages 3 & 4 will not print duplex.  Other than printing to pdf (which saves it, then I have to open that document and print from there which is a PAIN), can I print those 4 pages onto 2, or am I stuck? I have searched the internet to no avail.  Thanks!

6 Replies

Hi Adrienne,

 

As variant, did you check your default page size is the same on old and new PC:s, (was A4 and now A4) or changes (e.g. was A4, become Letter)?

 

Not sure that's an Excel issue.

Hi,

We are having the same problem. Did you get a solution to your issue?

I can recreate this with Excel 2016 both with and without O365 but Office 2010's Excel will print double-sided and in colour no problem.

All updates applied and so far I haven't found a solution online. Still looking though...

cheers,

Colleen

Having the same problem with Excel 2016 not printing on both sides of paper, No matter what it prints single pages. Strange that no problem with Word documents? Also, PDF docs are fine also. Just the EXCEL files. Didn't have any problems until after some update was automatically downloaded with the 365 added. I uninstalled the 365 since I didn't want it. Also uninstalled EXCEL 2016 as suggested from some tech at MS support. Re installed and it didn't have and effect. Very frustrated, MS has been of little to no help with this!

After searching the net for a resolution to the excel not duplexing I read this post. I loaded my simple sheet into Libre Office and it will also not print multiple copies of the sheet by duplex. I printed the sheet to a pdf and Acrobat will not print it in duplex mode. It is my conjecture that the problem is in-coded in the sheet itself. Libre Office and Acrobat have not problem printing other documents and duplexing. I have put all the time I am going to into this issue, it's much faster for me to just duplex it manually.

@Adrienne Schroder 

 

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.

@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! 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies