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
You are welcome! Glad it helped! 😀
LikeLike
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!!
LikeLike
How to excel 7 customise Ribbon? & coppy past hide?
LikeLike