Export Ribbon Customizations to a File Ms Excel 2010

You can make it easy to apply Ribbon and Quick Access Toolbar customizations on another computer by exporting your own customizations to a file. Customizing the Ribbon or the Quick Access Toolbar is not a difficult process, but it can be time-consuming, particularly if you want to make a substantial number of changes.

If you use Excel 2010 on another computer, it is likely that you will want to have the same customizations on the other computer so that you are dealing with a consistent interface no matter where you do your spreadsheet work. Rather than wasting valuable time repeating the same customization steps on the other computer, you can export your customizations to a file. You can then import that file on the other computer, and Excel automatically applies the customizations for you.

1. Right-click any part of the Ribbon.
2. Click Customize the Ribbon.
3. The Excel Options dialog box appears.
• Excel automatically displays the Customize Ribbon tab.
4. Click Import/Export.
5. Click Export All Ribbon and Quick Access Toolbar 
• Customizations. The File Save dialog box appears.
6. Choose a location for the customization file.
7. Type a name for the file.
8. Click Save. Excel saves the customizations to the file.
9. Click OK.

To apply the Ribbon and Quick Access Toolbar customizations on another computer running Excel 2010,

you need to import the customization file that you exported by following the steps in this section. Note, however, that importing a customization file replaces any existing customizations that you have created. On the computer you are customizing, right-click any part of the Ribbon, and then click Customize the Ribbon to open the Excel Options dialog box with the Customize Ribbon tab displayed. Click the Import/Export drop-down arrow and then click Import Customization File. In the File Open dialog box, locate and then click the customization file, and then click Open. When Excel asks you to confirm that all of your existing customizations will be replaced, click Yes and then click OK. Excel applies the Ribbon and Quick Access Toolbar customizations.

Categories: Excel 2010