MS Office 2007 Quick Access Toolbar Customization

I wrote in a previous blog that a good way to help your team transition to MS Office 2007 is to add one-click buttons to their applications. This saves them having to find where the option is to add bullets, for example, in the ribbon.

While building a new network recently we wanted to do this for the entire team. We learned that the customizations are saved as *.qat (Quick Access Toolbar) files and stored in the 'c:\documents and settings\{username}\local settings\application data\microsoft\office' folder. Armed with that, we set up the Quick Access Toolbars the way we wanted them on one system, and then copied the *.qat files to each user's local configuration folder.

And, just like that, all users had the modified Quick Access Toolbars they needed to stay productive during the transition!