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
Highlighted
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
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies