Copying the Quick Access Toolbar

by Allen Wyatt
(last updated October 6, 2020)

12

Alan makes extensive use of the Quick Access Toolbar, tweaking it constantly. He just bought a new laptop and would love to transfer the QAT from his other computer to the laptop.

Transferring your Quick Access Toolbar from one system to another is relatively easy, but it depends on the version of Word you are using. If you are using Word 2007 on both systems, you can transfer the toolbar by doing a search for the file "Word.QAT". This file contains your modifications to the toolbar. The default location for the file should be here:

C:\Users\[username]\AppData\Local\Microsoft\Office\

Simply copy the file from one computer to the other, restart Word on the destination computer, and you should be good to go.

If you are using Word 2010 or a later version, then the QAT file no longer exists. Instead, Word uses a file called Word.OfficeUI. You can find the file in the same directories where the QAT file was stored in Word 2007. Again, just copy the file from one system to another that uses the same version of Word (for instance: from one Word 2019 system to another) and you should be OK.

You should note that the Word.OfficeUI file contains more than just the Quick Access Toolbar configuration changes. It also contains information about your changes to the Word ribbons. So, if you copy the file from one system to another, then the target system will have the same QAT and ribbon customizations as the source system.

Word 2010 and later versions do provide a more flexible way to transfer the Quick Access Toolbar. Follow these steps:

  1. Display the File tab of the ribbon and then click Options. Word displays the Word Options dialog box.
  2. At the left side of the dialog box click either Customize Ribbon or Quick Access Toolbar. (It really doesn't matter which one you click.) (See Figure 1.)
  3. Figure 1. The Quick Access Toolbar options of the Word Options dialog box.

  4. At the bottom-right of the dialog box click the Import/Export drop-down list. Word displays a couple of options.
  5. Choose Export All Customizations. Word displays the File Save dialog box.
  6. Use the controls in the dialog box to select where you want to save your customizations and what name you want to use for the file.
  7. Click Save. Word saves your customization file.

When it comes time to use the exported information on a new system, just repeat the same steps but use Import Customization File in step 4.

All of the steps provided so far assume that you are transferring the Quick Access Toolbar between systems that use the same version of Word. This breaks down a bit if you are trying to transfer to or from Word 2007 and Word 2010 or a later version of Word. If you are transferring from a Word 2007 system to one that uses a later version of Word, then you can try copying Word.QAT from the Word 2007 to the later system. You should rename the file to Word.OfficeUI and restart Word. You can also use the Import capabilities of Word 2010 or a later version to import the QAT information.

If you need to copy a customized Quick Access Toolbar from Word 2010 or a later version back to Word 2007, then you can try to use the Export capabilities to export your customizations. The file that is created by exporting can be renamed to Word.QAT and copied to the Word 2007 system. Restart Word and you should notice the new Quick Access Toolbar. (The Word 2007 system should ignore any toolbar changes in the customization file.)

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (9920) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Office 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Ensuring Consistent Lines on Each Page

Need to have a specific number of lines on each page in your documents? What if those documents are subdocuments to a ...

Discover More

Taskbar Setting isn't Sticky

Understanding how Excel sets the taskbars upon opening.

Discover More

Direction Arrows Confused

What do you do if you open a document, only to find that the arrow keys don't work the way that they should? The first ...

Discover More

Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!

More WordTips (ribbon)

Putting Shift+F4 On the Quick Access Toolbar

The Shift+F4 shortcut is very helpful when you want to repeat an action, such as finding the next occurrence of whatever ...

Discover More

Putting a Macro Name on the Quick Access Toolbar

In older versions of Word you could customize the program so that either icons or text (or both) could appear on the ...

Discover More

Removing Styles from the Quick Access Toolbar

Got something on the Quick Access Toolbar that you don't need there anymore? Here are two quick ways to get rid of that item.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven more than 4?

2021-06-29 03:08:20

OzMerry

In response to Jan Blackston:

For the AppData folder to be visible, you need to check the "Hidden items" checkbox on the View tab in File Explorer. This option is unchecked by default.

(see Figure 1 below)

Figure 1. File Explorer - View Tab - Hidden items


2021-05-09 02:52:16

Alan Elston

Hi there Charles, that is going to be useful to me in the near future, thanks for adding that.
Alan Elston
( Doc.AElstein )


2021-05-08 16:10:34

Charles Kenyon

QAT modifications can be saved in a global template and easily moved that way regardless of Word version.
http://addbalance.com/word/QATmodification.htm


2020-06-17 09:35:39

Fred Seelig

Hi, Allen,

Could you update this, and other related posts?

I'm moving from Windows 7 and Office 2016/365 (it says both, for some reason) to a new PC: Windows 10, Office 365.

Additionally, I'm looking to move both my customized QAT and Ribbon, and all my macros, from both Word and Excel.

Thanks for all your help over the years.


2019-09-14 20:11:55

Peter

What is the use of telling us how to Save the QAT when it is somewhat easy to find. What I am trying to find out is how to save the thing from Word 2007, which does not have that same item in the Word Options.


2019-08-02 01:28:02

Jan Blackston

I am hoping you are some of the readers can help me. I was using Word 2007 on Windows 7 Platform. I purchased another computer that is running Windows 10, however still using Word 2007. I am attempting to move the old QAT file from the old computer to the new. I followed your instructions in the article and found the QAT file at C:Users\{username}\AppData\local\microsoft\office and copied them to a thumb drive.

The Challenge is the article states to find and replace the QAT files on the new computer.
However when going to C:\users\}username}\ there is no appdate\local\microsoft\office on this newer computer with Windows 10. I have done a search for QAT file and even the office UI file.
Where do I find the QAT file in word 2007 programs ran on Windows 10 platform. I really could use your help as I need those files to complete my work.
Thanks!
Jan Blackston


2018-12-06 13:04:06

John

Is there a way in Word 2013 to import only the QAT settings ; leaving the ribbon settings as they are?

In our shop, the ribbon and the QAT are customized centrally and refreshed during startup for each user. I would like to keep the ribbon settings as they are pushed but use my own settings for the QAT. Preferably I would like a QAT-only import to be run from a script at startup after the central push.


2016-09-09 22:56:30

Andre

Is there a way to keep the customizations in sync on two or more computers? So if I make changes to the toolbar on one computer it is reflected on the other computers automatically?


2016-07-24 12:27:20

Charles Kenyon

It is important to remember when using these methods that it overwrites any customizations already made on the system receiving the copy. In many cases this is just fine, especially when setting up a new system.

If more fine tuning is required, the QAT modifications should be stored in a separate template which can be loaded as a global.
http://addbalance.com/word/QATmodification.htm


2016-01-12 16:53:54

Rohn MVP

It appears that since the original release of 2010 MS has made a change via Windows Update.

I do remember seeing the .OfficeUI files, but now when I try to export I see the .ExportedUI file extension instead. And the file name has been expanded to "Word Customizations." rather than just "Word."


2015-09-11 16:36:20

Rodney

Moving QAT customizations from 2013 to 2007 didn't work at all for me. When I follow the instructions above, my QAT is reset to the default.


2015-06-26 17:26:22

nora

Brilliant! No where on the MS site could I find this.


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.