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

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies