Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.