Customizing Excel

Sharing Customizations with Others

If you have developed the perfect ribbon customization and you want everyone in your department to have the same customization, you can export all the ribbon customizations.

To export the changes, follow these steps:

1. Right-click the ribbon and select Customize The Ribbon.

2. Below the right list box, select Import/Export, Export All Customizations.

3. Browse to a folder and provide a name for the customization file. The file type will be .exportedUI. Click OK.

4. In Windows Explorer, find the .exportedUI file. Copy it to a co-worker’s computer.

5. On the co-worker’s computer, repeat step 1. In step 2, select Import Customization File. Find the file and click OK.

   NOTE

   This is an all-or-nothing proposition. You cannot export your changes to one custom tab without exporting your changes to the Data and Home tabs.