Microsoft Office Tutorials and References
In Depth Information
Export Ribbon Customizations to a File
Chapter 1: Making Excel More Efficient
The File Save dialog box
5 Choose a location for the
6 Type a name for the file.
7 Click Save.
Excel saves the
customizations to the file.
8 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.