Backup and Restore Your Office 2010 Ribbon And Quick Access Toolbar

As we all know in Microsoft Office 2010 we are able of customizing the Ribbon and the Quick Access toolbar. We can create our own Tab with all the commands that we use most, and we can add commands that we use more often on the Quick Access toolbar. Isn’t it a shame though, that we have to customize them all over again, if we work on a new pc, or new laptop.

Thankfully, we can save the customizations that we have made on the Ribbon and on the Quick Access toolbar on a file, and then import them in Office 2010 on another computer.

01

Below I will describe how this can be done. Be aware, that we can only save the customizations for one Office program at a time. For the example below I will be saving the customizations in Excel. The exact same steps are required for the other Office programs.

First of all we must press the File tab in order to go to backstage view. From the drop down menu that appears we must select the category Options at the bottom of the drop down menu as we can see in the image below.

02

Once the Excel Options dialog box appears, from the left we select the category Customize Ribbon as shown below. We can also click the Quick Access Toolbar. Whichever we choose all the customizations from both the Ribbon and the Quick Access Toolbar will be exported.

03

At the bottom right corner of the Customize Ribbon screen, the area named Customizations is located. We then click on the Import/Export drop down list, and from the drop down menu that appears we select the command Export All Customizations as we can see in the image below.

04

The File Save dialog box appears, where we navigate where we want the file to be saved, and then enter a name. Finally we press the Save button. We notice in the image below the extension of the file is .exportedUI (user interface).

05

We have successfully exported the customizations of our Ribbon and Quick Access Toolbar. Now, we can import it on any other computer that we want to.

In order to import the customization of our Ribbon and Quick Access Toolbar, we must follow the same steps as mentioned above.

Select the File tab, from backstage view to select the category Options. From the Excel Options dialog box we select the category Customize Ribbon or Quick Access Toolbar, and from the bottom of the window we select the Import/Export drop down list and from the drop down menu that appears we select the command Import Customization File as shown in the image below.

06

The File Open dialog box appears, where we navigate in order to locate the file, and once selected we press the Open button.

07

Once we press the Open button, a warning dialog box appears, asking us if we want to Replace All Existing Ribbon And Quick Access Toolbar Customizations For This Program? We then select Yes, in order for the customizations to imported.

08

We then press the OK button from the Excel Options dialog box in order to return to Excel.  That is it!!! All the customizations are imported.

09

Be aware, that when we import a customized file for the Ribbon and the Quick Access Toolbar, all adjustments that we had made previously to them will be lost.

The same procedure stands for all the other Office 2010 programs.

You can also check the video below, describing the steps in order to Import/Export all customizations of the Ribbon and the Quick Access Toolbar.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on April 18, 2012, in Microsoft Office 2010 English, Office 2010 English and tagged , , , , , , . Bookmark the permalink. Comments Off on Backup and Restore Your Office 2010 Ribbon And Quick Access Toolbar.

Comments are closed.