Home

Changing print orientation on all worksheets when printing a whole workbook in one go

%3CLINGO-SUB%20id%3D%22lingo-sub-789984%22%20slang%3D%22en-US%22%3EChanging%20print%20orientation%20on%20all%20worksheets%20when%20printing%20a%20whole%20workbook%20in%20one%20go%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789984%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20please%20can%20you%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20printing%20a%20workbook%20with%20multiple%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20change%20the%20print%20size%20of%20all%20sheets%20by%20either%20portrait%20to%20landscape%20or%20set%20all%20sheets%20to%20fit%20all%20columns%20to%20one%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20this%20be%20done%20without%20having%20to%20change%20each%20sheet%20individually%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-789984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPrinting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eworksheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790080%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20print%20orientation%20on%20all%20worksheets%20when%20printing%20a%20whole%20workbook%20in%20one%20go%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387935%22%20target%3D%22_blank%22%3E%40MikeCS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20select%20all%20your%20sheets%20(click%20on%20first%20one%2C%20Shift%2C%20click%20on%20last%20one)%20and%20with%20that%20Page%20Setup%20will%20be%20applied%20to%20all%20selected%20sheets%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790083%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20print%20orientation%20on%20all%20worksheets%20when%20printing%20a%20whole%20workbook%20in%20one%20go%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MikeCS
New Contributor

Hi - please can you help!

 

I am printing a workbook with multiple sheets.

 

I want to change the print size of all sheets by either portrait to landscape or set all sheets to fit all columns to one page.

 

can this be done without having to change each sheet individually?

2 Replies
Highlighted

@MikeCS 

You may select all your sheets (click on first one, Shift, click on last one) and with that Page Setup will be applied to all selected sheets

Highlighted
Related Conversations
Can't print in Edge IE mode
trandall in Enterprise on
1 Replies
What do these flags to exactly? [XPS and GDI printing]
HotCakeX in Discussions on
0 Replies
Window will not print, not even a test page
Hank_Leander in Windows 10 on
1 Replies
Printing of PDF's broken in DEV build 80.0.345.0
ToMMeR in Enterprise on
1 Replies
Excel Print Preview not matching the actual printed document
Gano1224 in Excel on
12 Replies