Once you have your ribbon customized perfectly and want everyone else to have the same, it’s a very easy task to share with your colleagues.
Follow the steps below to learn how:
- Right-click your Ribbon and select Customize the Ribbon.
- Just below the the list box to the right, select Import/Export | Export All Customizations.
- Browse to a folder and name your customization file. The file type will be .exportedUI.
- Click OK.
- In Windows Explorer, find the exported .exported UI file and copy it to a colleague’s comuputer.
- On your colleague’s computer, repeat step one and two above.
- Select to Import All customizations.
- Find your file.
- Click OK.
Should you later change your mind, that is a very easy task as well:
- Right-click your Ribbon and select Customize the Ribbon.
- Just below the list box on the right, select Rest | Reset All customizations.
- Click OK.
Version 2007- 2010
Does not work for excel 2013 64bit as the users profile name is saved as part of the file