Updated: Feb 24, 2020
The Quick Access Toolbar (QAT) does exactly what it says on the tin. It allows you to quickly access commands or menu options, that you may use on a regular basis or options you have trouble finding within the tabs.
The great thing about the QAT is that it is always at the top of your screen. It is available in the Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Publish and Visio.
In this blog I will show you 3 different ways on how to customise the Quick Access Toolbar. The steps below are in Excel but the priniciples are the same across all the Microsoft Office applications.
Do you see something on your menu ribbon that you use on a regular basis? Perhaps you’re fed up clicking through the tabs trying to find what you’re looking for?
When you see the icon you want to add to your QAT – Just simply right-click on the icon and select Add to Quick Access Toolbar.
2. Drop-down List
On the QAT itself you can choose from a list of options by clicking on the drop-down menu. Just simply click on the options that you think would be useful, for example, Quick Print.
3. More Commands
There are 100s of commands to choose from. Many of which are hidden gems! Like adding a Calculator to your QAT.
To see the list of commands available, click on the drop-down menu and select More Commands.
You can pick from the Popular List, Commands Not in the Ribbon or to get the full range, select All Commands.
Select the option you wish to add to the QAT, click Add and OK to Complete.
Top tip: To save time scrolling through the list of options, just click on the first one and then type what you're looking for.
The icon will then be available on your QAT.
5 Hidden Gems to add to your Excel Quick Access Toolbar Watch the video below to see 5 amazing options to add to your QAT in Excel.
I'm always looking for new ideas for topics. If you have a suggestion you would like me to cover or think would be useful, then please email: Suggestions@ReadySteadyXL.com