Customized Ribbon and QAT is very common.  I believe all serious Excel users will have their own customized Ribbon and QAT according to their own working habits.

I rarely share my customization with others and I am not going to share here, as I just said, it’s really up to your working habits.  You won’t find my customized QAT valuable to you at all… I guess :p

Nevertheless, you should need to know how to copy your customized Ribbon and QAT to another PC, especially when you switch job which I recently did.  🙂

1) Export

Go to File –> Options –> Customize Ribbon –> Import/Export –> Export all customizations

Then select the path you want to save the file.  Once it’s done, you should see the following file in your destination folder.

2) Import

Repeat the step 1) but select “Import customization file”… Well you should have the EXPORTEDUI File ready of course 🙂

As simple as that.

Note: This will replace your existing QAT and Ribbon customizations, if any.

========================================================================

Want to learn Excel Dashboard but didn’t know where to start?

Don’t miss the FREE webinar to be hold by MYNDA TREACY of myonlinetraininghub.  In the webinar, Mynda will show you the fact that building an Excel Dashboard is actually easier than what you may have thought about.