The QAT or Quick Access Toolbar can be really useful when you've customised it by adding your favourite functions and commands as a shortcut to the QAT. Exporting your QAT can also be really useful if your company resets your customisations whenever you log off or your colleagues would like to use the same shortcuts you do.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
To share it with colleagues or save it as a backup, click on the drop down menu next to the QAT and select More Commands. Next select the Import/Export button on the bottom left of the Customise QAT box that has opened:
Select a suitable file name and location and click on OK.
To import this file, follow the steps as above and select Import instead of Export. Navigate to where this file has been saved and click on ok to import it into your programme.
This same procedure can be repeated if you've created a custom ribbon and is identical on all Microsoft Products e.g. Word, Excel, PowerPoint, Access, Outlook, Visio, Project, etc.
An example set of useful commands in Word:
Save, Undo, Redo, Spelling & Grammar, New File, Change Page Orientation, Font Settings, Insert Page Section Breaks, Insert Comment, Add a Cover Page, Start Mail Merge, Add a Chart, Switch Windows, Format Painter, Add Table, Paste and Use Destination Styles, Email as PDF.
Quick Print, Clear Formats, Information, Calculate Now, Decrease Font Size, Add or Remove Filters, Freeze Panes, Page Setup, Refresh All, Set Print Area, Sum, Insert Table, Undo, Email, Email as PDF.
Want Better Excel Skills?
We have online courses with full 12-months' access. RRP from $49 limited time offer just $12.00
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.