Home

No setting default margins?

%3CLINGO-SUB%20id%3D%22lingo-sub-868189%22%20slang%3D%22en-US%22%3ENo%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868189%22%20slang%3D%22en-US%22%3E%3CP%3EI%20noticed%20this%20note%20when%20perusing%20the%20help%20topic%20for%20page%20layout%20in%20Excel%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22excel%20colorful%22%3E%3CDIV%20class%3D%22grd%20%22%3E%3CDIV%20class%3D%22row%22%3E%3CDIV%20class%3D%22col-5-5%22%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%22%3ENote%3A%20Page%20margins%20that%20you%20define%20in%20a%20particular%20worksheet%20are%20stored%20with%20that%20worksheet%20when%20you%20save%20the%20workbook.%20You%20can't%20change%20the%20default%20page%20margins%20for%20new%20workbooks.%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3EI%20am%20really%20curious%20why%20this%20feature%20would%20be%20taken%20away.%26nbsp%3B%20It%20seems%20short%20sighted%20to%20stop%20allowing%20users%20to%20set%20up%20their%20default%20template%20for%20office%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-868189%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887549%22%20slang%3D%22en-US%22%3ERe%3A%20No%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887549%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412691%22%20target%3D%22_blank%22%3E%40listondavis%3C%2FA%3E%26nbsp%3BYou%20can%20apply%20all%20the%20custom%20settings%20you%20want%2C%20then%20save%20a%20template%20workbook.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcustomize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECustomize%20how%20Excel%20starts%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889169%22%20slang%3D%22en-US%22%3ERe%3A%20No%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-889169%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3BPage%20margins%20aren't%20included.%26nbsp%3B%20My%20OP%20was%20a%20direct%20quote%20from%20Microsoft%20Help%20in%20Excel%2C%20where%20they%20say%20that%20page%20margins%20can't%20be%20changed%20as%20a%20default%20setting.%26nbsp%3B%20Up%20until%202016%20or%20so%2C%20that%20was%20not%20the%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESettings%20that%20you%20can%20save%20in%20a%20workbook%20or%20worksheet%20template%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3ECell%20and%20sheet%20formats.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EPage%20formats%20and%20print%20area%20settings%20for%20each%20sheet.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ECell%20styles.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EThe%20number%20and%20type%20of%20sheets%20in%20a%20workbook.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EProtected%20and%20hidden%20areas%20of%20the%20workbook.%20You%20can%20hide%20sheets%2C%20rows%2C%20and%20columns%20and%20prevent%20changes%20to%20worksheet%20cells.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EText%20you%20want%20to%20repeat%2C%20such%20as%20page%20headers%20and%20row%20and%20column%20labels.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EData%2C%20graphics%2C%20formulas%2C%20charts%2C%20and%20other%20information.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EData%20validation%20settings.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EMacros%2C%20hyperlinks%2C%20and%20ActiveX%20controls%20on%20forms.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22%22%3EWorkbook%20calculation%20options%20and%20window%20view%20options.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889285%22%20slang%3D%22en-US%22%3ERe%3A%20No%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-889285%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412691%22%20target%3D%22_blank%22%3E%40listondavis%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20heads%20up.%20I%20suppose%20an%20alternative%20would%20be%20to%20record%20a%20macro%20applying%20your%20page%20setup%20settings%2C%20then%20add%20that%20to%20your%20Personal.xlsb%20workbook.%20That%20way%20it%20will%20be%20available%20to%20any%20open%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889293%22%20slang%3D%22en-US%22%3ERe%3A%20No%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-889293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3BFair%20point.%26nbsp%3B%20While%20it's%20not%20ideal%20to%20lose%20the%20feature%20out%20of%20the%20box%2C%20this%20is%20a%20solution%20that%20works%20fine%20for%20me%20as%20I%20will%20extensively%20use%20VBA.%26nbsp%3B%20Appreciate%20the%20workaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889299%22%20slang%3D%22en-US%22%3ERe%3A%20No%20setting%20default%20margins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-889299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412691%22%20target%3D%22_blank%22%3E%40listondavis%3C%2FA%3E%26nbsp%3BI'll%20see%20if%20I%20can't%20get%20in%20touch%20with%20the%20PM%2C%20and%20find%20out%20why%20it'snot%20supported%20anymore.%3C%2FP%3E%3C%2FLINGO-BODY%3E
listondavis
New Contributor

I noticed this note when perusing the help topic for page layout in Excel Office 365.

 

Note: Page margins that you define in a particular worksheet are stored with that worksheet when you save the workbook. You can't change the default page margins for new workbooks.

 

I am really curious why this feature would be taken away.  It seems short sighted to stop allowing users to set up their default template for office

5 Replies

@listondavis You can apply all the custom settings you want, then save a template workbook.

 

See: Customize how Excel starts.

 

HTH,

@Smitty Smith Page margins aren't included.  My OP was a direct quote from Microsoft Help in Excel, where they say that page margins can't be changed as a default setting.  Up until 2016 or so, that was not the case.

 

Settings that you can save in a workbook or worksheet template

  • Cell and sheet formats.

  • Page formats and print area settings for each sheet.

  • Cell styles.

  • The number and type of sheets in a workbook.

  • Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.

  • Text you want to repeat, such as page headers and row and column labels.

  • Data, graphics, formulas, charts, and other information.

  • Data validation settings.

  • Macros, hyperlinks, and ActiveX controls on forms.

  • Workbook calculation options and window view options.

@listondavis Thanks for the heads up. I suppose an alternative would be to record a macro applying your page setup settings, then add that to your Personal.xlsb workbook. That way it will be available to any open workbook.

@Smitty Smith Fair point.  While it's not ideal to lose the feature out of the box, this is a solution that works fine for me as I will extensively use VBA.  Appreciate the workaround.

@listondavis I'll see if I can't get in touch with the PM, and find out why it'snot supported anymore.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies