Take the 2-minute tour ×

I have customized Ms Excel to my needs, for example I have written small macros and attached them as buttons to the quick access toolbar, made the Developer tab visible etc.)

Is there any way to export these settings to a file?

So that;

I can use the same settings on different computers I work,

Restore my settings when needed

Distribute to people who ask for it.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

In Excel you can backup several parts of the configuration individually. To back them all up you'd need to create a migration profile using something like the file and settings transfer wizard.

Ribbon customizations can be exported to a file. Right click on the ribbon, select Customize Ribbon, and in the lower right section of the window there is an Import/Export button.

The macros themselves are stored where you choose to store them and you can migrate these as well pretty simply.

Many of the other settings are stored in the registry. Most are per-user and so are stored here: HKEY_CURRENT_USER\Software\Microsoft\Office\\Excel.

Others would be stored in HKLM...

share|improve this answer

Your Answer


