Export/Import Ribbon & Quick Access Toolbar Settings [Office 2010]

Microsoft Office suite apps provides an easiest way to customize Ribbon, Tabs and Quick Access toolbar but what if you need to install a fresh copy of Office or use these customizations on other system? Office 2010 allows you to export/import customizations. In this post we will walk you through the procedure of exporting/importing ribbon and Quick Access toolbar customizations.

To begin with, open an Office app for which you want to export the ribbon tabs and Quick Access toolbar settings. For instance, we have opened Excel 2010, containing customized tabs such as; Outlook, New, and Developer & Quick Access toolbar having added commands.

For using Excel with all these customized tabs and Quick Access toolbar on another system, first you need to export ribbon settings. Navigate to File menu and click Options.

options10 Export/Import Ribbon & Quick Access Toolbar Settings [Office 2010]

From left side bar, select Customize Ribbon and from main dialog window, under Customizations and from Import/Export options, click Export all Customizations.

excel options

File Save dialog will appear, click Save to export the customizations.

save custo

Now for importing these settings on another system running Excel 2010. Open Excel window, from File menu, click Options to reach Excel Options dialog. From left side, select Customize Ribbon and from main dialog window, under Customizations and from Import/Export options, click Import Customization file.

import

Navigate to location where export file is residing, select the file and click Open.

select file

Upon click, it will bring all the saved ribbon tabs and Quick Access toolbar commands.

tabs

Follow the same procedure for other Office apps, such as, Word, Outlook, Access, OneNote, and more.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *