How to customise the Quick Access Toolbar

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.

Quick Access Toolbar (QAT)

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.

1. Right-click

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.

Right-lick Icon to 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.

Click on the drop-down list of the Quick Access Toolbar

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.

More Commands Available to add to you Quick Access Toolbar

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.

Select from a range of options

The icon will then be available on your QAT.

Once added the icon will then appear on your Quick Access Toolbar

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.

Suggestions

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