Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .