When printing entire workbook with portrait and landscape sheet orientations, Excel prints portrait.

%3CLINGO-SUB%20id%3D%22lingo-sub-1297120%22%20slang%3D%22en-US%22%3EWhen%20printing%20entire%20workbook%20with%20portrait%20and%20landscape%20sheet%20orientations%2C%20Excel%20prints%20portrait.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1297120%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20whole%20workbook%20with%2010%20sheets.%20I%20need%20one%20of%20the%20sheets%20to%20print%20in%20landscape%20orientation%20and%20I%20need%20all%20the%20other%20sheets%20to%20print%20in%20portrait%20orientation.%20I%20want%20to%20print%20the%20entire%20workbook%20in%20one%20print%20job%20instead%20of%20in%20two%20print%20jobs.%20Even%20though%20I%20went%20into%20Page%20Setup%20on%20each%20sheet%20and%20indicated%20which%20orientation%20I%20want%20to%20print%2C%20excel%20only%20prints%20portrait%20for%20all%20of%20the%20sheets%20when%20I%20print%20the%20whole%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20order%20of%20operations%3A%3C%2FP%3E%3CP%3E1.)%20After%20I%20select%20the%20individual%20orientations%20for%20each%20sheet%2C%20I%20go%20back%20through%20each%20sheet%20to%20make%20sure%20that%20Excel%20saved%20the%20orientation%20setting%20I%20wanted%20for%20each%20individual%20sheet.%20Excel%20shows%20that%20it%20has%20saved%20the%20correct%20orientation%20for%20each%20sheet.%3C%2FP%3E%3CP%3E2.)%20I%20then%20save%20the%20workbook%20and%20again%20I%20check%20each%20sheet%20to%20make%20sure%20that%20Excel%20saved%20the%20orientation%20setting%20I%20wanted%20for%20each%20individual%20sheet.%20Excel%20shows%20that%20it%20has%20saved%20the%20correct%20orientation%20for%20each%20sheet.%3C%2FP%3E%3CP%3E3.)%20When%20I%20check%20the%20print%20preview%2C%20Excel%20indicates%20that%20all%20of%20the%20sheets%20will%20be%20printed%20in%20the%20portrait%20orientation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20is%20a%20bug%20or%20am%20I%20doing%20something%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1297120%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1297146%22%20slang%3D%22en-US%22%3ERe%3A%20When%20printing%20entire%20workbook%20with%20portrait%20and%20landscape%20sheet%20orientations%2C%20Excel%20prints%20portr%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1297146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616542%22%20target%3D%22_blank%22%3E%40Elan_Moyal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20Excel%20is%20built%20to%20primarily%20print%20using%201%20orientation%20per%20time.%20It%20is%20not%20possible%20to%20print%20using%20Landscape%20and%20Portrait%20at%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20separate%20the%20page%20you%20want%20to%20print%20using%20Portrait%20and%20Landscape%20respectively%20and%20print%20the%20job.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EIf%20this%20answers%20suits%20you%2C%20kindly%20do%20accept%20as%20the%20Best%20Response.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EThank%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a whole workbook with 10 sheets. I need one of the sheets to print in landscape orientation and I need all the other sheets to print in portrait orientation. I want to print the entire workbook in one print job instead of in two print jobs. Even though I went into Page Setup on each sheet and indicated which orientation I want to print, excel only prints portrait for all of the sheets when I print the whole workbook.

 

Here is my order of operations:

1.) After I select the individual orientations for each sheet, I go back through each sheet to make sure that Excel saved the orientation setting I wanted for each individual sheet. Excel shows that it has saved the correct orientation for each sheet.

2.) I then save the workbook and again I check each sheet to make sure that Excel saved the orientation setting I wanted for each individual sheet. Excel shows that it has saved the correct orientation for each sheet.

3.) When I check the print preview, Excel indicates that all of the sheets will be printed in the portrait orientation.

 

Is this is a bug or am I doing something wrong?

2 Replies
Highlighted

@Elan_Moyal 

 

Hello, Excel is built to primarily print using 1 orientation per time. It is not possible to print using Landscape and Portrait at the same time. 

 

You have to separate the page you want to print using Portrait and Landscape respectively and print the job.

 

If this answers suits you, kindly do accept as the Best Response.

 

Thank

Highlighted

HI @Elan_Moyal 

I believe I've seen this done by converting the workbook into a PDF first. If you have that ability, I suggest giving it a try.