Microsoft Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 training 
 Home Products Programs Meet Dawn Free Newsletter Media Room Contact
Tip: Quick Access Toolbar  

Services
Tips & Tricks
The Pro Shop
How-To Lessons
Free Articles
Newsletter
Resources

 
Dawn Bjork Buzbee
The Software Pro
®

Microsoft Certified Trainer (MCT)

Certified Microsoft Office 2007 Master Instructor

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Specialist Master Instructor

Certified Microsoft Office Expert

Certified Women's Business Enterprise (WBE)

(303) 699-6868
Dawn@SoftwarePro.com


Microsoft Office 2007 Tip

Category: Office Customizing
Versions: Microsoft Office 2007

>>More Microsoft Office 2007 Tips & Tricks

How to copy Microsoft Office 2007 Quick Access Toolbar (QAT) settings from one computer to another
So you've painstakingly set up your customized Quick Access Toolbar preferences in every Microsoft Office 2007 program. You have your favorite shortcuts for sorting and formatting Excel worksheets, responding to Outlook e-mails, and locating those Not in the Ribbon icons you need in your Word documents. What if you want to share these preferences with a co-worker or your home computer? Do you have to re-create all of the steps you worked so hard to get the first time? Let's look at an easy solution to transfer your Quick Access Toolbar settings to another PC.

One technique to copy your settings is with transfer or migration tools which require administrative access--darn! Fortunately, you can skip the help desk ticket or the costly visit from your IT support guru and simply copy a few files. Your Quick Access Toolbar (QAT) settings are stored in your Application Data folder. The files are named Access.qat, Excel.qat, PowerPoint.qat, and Word.qat. Outlook may have multiple .qat files if you have customized the toolbars for multiple actions such as creating a new e-mail message or adding a new calendar entry. Here are the locations:

Windows 7 & Windows Vista:
C:\Users\<username>\AppData\Local\Microsoft\Office\*.qat

Windows XP:
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Office\*.qat

Simply copy the QAT file associated with the program which has the customized Quick Access Toolbar from your source computer to the same location on the other computer. Easy--all of your efforts are saved!

>>More Tips & Tricks

Go To Top of Page
 



Tips, Tricks, Secrets that you need to know now!
Discover the secrets that you wish you knew before...all of this plus 15 BONUS SHORTCUTS and access to handouts with 350+ MORE SHORTCUTS AND TIPS when you sign-up for the Smart & Easy Software Tips & Tricks eMagazine!

Start Being More Productive Today!
CLICK HERE to sign-up directly via email.
Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
 
www.SoftwarePro.com
HomeServices | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 1995-2009 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
§ Dawn@SoftwarePro.com § 11675 Bent Oaks Street, Suite 200; Parker, Colorado 80138 USA § www.SoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
§ Certified Microsoft Office 2007 Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor (Office 2007 & Windows Vista)
Certified Microsoft Office Specialist Master Instructor
§ Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro
® is a registered trademark
Terms & Conditions       Privacy Policy