Predefined margins - EXCEL 2010

Question

How do I edit the 3 predefined margins? (normal, wide & narrow) to suit how I want them, I do not want to have to create custom margins each time.

Excel 2010

Answer 1

What she wants is that every time you hit "New"  the page will automatically come up with the margins the way you want them.  For instance I never want header, I want my side margins to be .75 not .7, who decided to do that????  I want my footer to be set to .5, who made it .3????  That's stupid.  We could do this in XP.  Are you saying with all the advances in 2010,  you can't change the margin defaults?????  What are we paying for?

Personally, I never do macros nor do I want to start.  Waaaaaayyyyyyy too many steps.

Does it matter which Windows it is?  i.e. Windows 7

Answer 2

I think what Mauro is telling you is; No, there is no way to change Excel's default margins, but you can set custom margins and record your actions in a macro.

In Mauro's post, where he states "set wide margins" you need to go to File -> Print and set custom margins for the "Wide" macro to whatever settings you like. Do the same for Narrow and Normal. You will then end up with 3 macros that you can call from 3 buttons on your QAT.

Perhaps not quite what you wanted, but probably best we can do.

---

Ed Ferrero www.edferrero.com

Answer 3

how does this let me edit the settings, all this does is create button which are already there. I want to change the defaults of the margins to suit me.

Answer 4

How do I edit the 3 predefined margins? (normal, wide & narrow) to suit how I want them, I do not want to have to create custom margins each time.

Excel 2010

Try:

• Tab: View
• Macros-->Record Macro...
• Macro name: Wide
• Store macro in: Personal Macro Workbook
• Ok
• Set wide margins
• Tab: View
• Macros-->Stop Record
• Macros-->Record Macro...
• Macro name: Narrow
• Store macro in: Personal Macro Workbook
• Ok
• Set narrow margins
• Tab: View
• Macros-->Stop Record
• Macros-->Record Macro...
• Macro name: Normal
• Store macro in: Personal Macro Workbook
• Ok
• Set normal margins
• Macros-->Stop Record

Now you can put three buttons that call the macro on the Quick Access Toolbar:http://www.contextures.com/excel-quick-access-toolbar-customize.html

---

Mauro Gamberini - Microsoft© MVP(Excel)

http://www.maurogsc.eu/