Printing Double Sided in Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1128232%22%20slang%3D%22en-US%22%3EPrinting%20Double%20Sided%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1128232%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20my%20excel%20workbook%20set%20up%20so%20that%20each%20sheet%20is%20one%20section.%20I%20would%20like%20to%20print%20each%20section%20double%20sided%2C%20but%20not%20crossover%20into%20the%20next%20section.%20For%20example%2C%20I%20don't%20want%20the%20last%20page%20of%20the%20first%20section%20to%20be%20on%20the%20same%20physical%20page%20as%20the%20first%20page%20of%20the%20next%20section.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20in%20settings%20and%20still%20print%20the%20entire%20workbook%20as%20opposed%20to%20printing%20each%20sheet%20separately%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1128232%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have my excel workbook set up so that each sheet is one section. I would like to print each section double sided, but not crossover into the next section. For example, I don't want the last page of the first section to be on the same physical page as the first page of the next section. 

 

Is there a way to do this in settings and still print the entire workbook as opposed to printing each sheet separately?

 

Thanks!

1 Reply

@toridivita 

 

If I understand what you're describing here, you're trying to accomplish in Excel what Word makes easy with Section Break Odd Page in Word's "Insert Break" function.

 

If Excel doesn't have that--and I'm assuming you've looked even harder than I just did--one suggestion would be to "print to PDF" and then use a package like PDF Expert to insert a blank page as the otherwise missing even numbered page on the back of the last page of the preceding section. Granted, that's not as neat a solution as having Excel just do it for you, but you'd have your new sections beginning on the odd numbered pages as desired.