March 22, 2007
Customizing and Roaming the Quick Access Toolbar in Word, Excel, Outlook, PowerPoint 2007
The other day I had some downtime, so I decided to customize the Quick Access Toolbar in Outlook 2007 to improve my efficiency:
Sweet! Now I can flag an email as low importance, flag as high importance, check names in the To/CC fields, switch between plain text and HTML, left justify, center justify, show the BCC field, change the font name/size/color/highlight, and even delete the mail.
How convenient!
Even better, I found out that these customizations are stored on your hard drive as .QAT files! You can find them here:
C:\Users\[your user account]\local settings\Microsoft\Office
Sweet! I went and customized Word, PowerPoint, and Excel as well, copied their QAT files to a FolderShared folder, and then copied the customizations to all my machines.
I feel more productive already.
Add to your Toolbar
4 Comments to “Customizing and Roaming the Quick Access Toolbar in Word, Excel, Outlook, PowerPoint 2007”
May 8th, 2007 at 6:10 am
This article was extremely helpful in providing the location of .QAT files which capture the settings of the Quick Access Toolbars. I did not find any reference to the file names or location in anything I checked on the Microsoft web sites. Good for you!!
Duane
March 18th, 2008 at 7:11 am
When using this qat files in a roaming profile environment, the qat files does not roam. Besides adding a logoff and logon script for these files, are there any other suggestions?
July 1st, 2008 at 7:06 pm
Awesome instructions! Thanks for documenting this! To make this function for anyone logging into the PC, I will try copying it to the default user profile.
August 19th, 2008 at 5:25 pm
A number of Group Policy scripting solutions have been proposed with various repositories including the user’s mapped data drive and even the user’s desktop
Microsoft should have stored the qat files in the user’s permanent application data tree where they would get picked up by the roaming profile. Simply use GP scripts to copy them to and from here.
I have posted the simple scripts required.
http://www.technologyquestions.com/technology/microsoft-office/232919-office-2007-roaming-qat-quick-access-toolbar.html
Leave a Reply