Copy customized Ribbon and QAT to another PC

Excel Tips - Copy Ribbon and QAT

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 customizationsExcel Tips - Copy Ribbon and QAT1Excel Tips - Copy Ribbon and QAT2

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

Excel Tips - Copy Ribbon and QAT3

2) Import

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

Excel Tips - Copy Ribbon and QAT4

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 

Free Excel Dashboard Webinar

This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s