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

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

3 Responses to Copy customized Ribbon and QAT to another PC

  1. MF says:

    You are welcome! Glad it helped! 😀


  2. Gregg Taylor says:

    Thank you very much for posting this!! I had to get a new computer which has Office 365, so even though I was able to copy my Personal.xlsb, I lost the customized ribbon which I had developed over the course of 4-1/2 years. This post saved me an enormous amount of time!!


  3. Mabebubkhan says:

    How to excel 7 customise Ribbon? & coppy past hide?


Comments, suggestions, corrections are welcome.

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

You are commenting using your 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.