Quick Access Toolbar In Excel (QAT)

Article byVenkateshwaran Nagarajan
Edited bySheeba M
Reviewed byDheeraj Vaidya, CFA, FRM

What Is The Quick Access Toolbar (QAT) In Excel?

Quick Access Toolbar, or QAT in Excel, is a toolbar available on the Title Bar of an Excel window, where we can position our important shortcuts and use them much easier whenever necessary. It is a customizable toolbar containing a set of commands visible at the top of the ribbon, which is independent.

For example, we can add or remove the buttons of our choice by customizing the toolbar, but we cannot resize it, as shown below.

Quick Access Toolbar - New

Now, when we select the “New” option, it gets ticked, i.e., added to the QAT, as shown below.

Quick Access Toolbar - New Added

We can create custom tabs and groups to choose the frequent and repeatedly used commands.

Key Takeaways

  • The Quick Access Toolbar in Excel (QAT) is a feature found, by default, at the top of the Office application window. The toolbar can be placed above or below the ribbon, and can even be hidden.
  • We can choose the commands we use frequently, such as Save, Undo, Redo, etc.
  • It is a useful feature, because most of the time, we may not remember the shortcut keys for repeatedly used commands. It helps us use it instantly and saves time.
  • We can add/remove commands as per our use and requirement. Then we can Export/Import our customized settings for future use on different computers.

How To Use Quick Access Toolbar In Excel?

We can use the Quick Access Toolbar from two possible locations: one at the top of the ribbon and the other at the top of the workspace area.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Examples

We will consider examples of using the Excel Quick Access Toolbar.

Example #1 – Customizing QAT

The steps to Customizing QAT, i.e., to click the appropriate tab or group on the ribbon to display the command we want to add to the toolbar, are as follows:

  1. Choose the left-click command on the Excel Quick Access Toolbar shortcut menu. Then, customize QAT to more commands like “Open,” “Save,” “Undo,” “Redo,” etc., by clicking the left click on the “Commands.”


    Quick access toolbar example 1.2

  2. If the command is already available in the toolbar in Excel, it shows a tick mark at the left of the tab. We can remove the command if we do not need it.

  3. Suppose we want to add more commands not displayed in the list. Do not worry. Click on the “More Commands” button to add or remove the commands at the bottom of the tab.


    Quick access toolbar example 1.1

  4. The “Excel Options” window will appear if we choose the “More Commands” tab.


    Quick access toolbar example 1.3

  5. If we select the commands from the drop-down menu, we can choose the menus we want to add. By default, it shows the popular commands mostly recommended by the users.

  6. We can select the reference tabs if it is difficult to find the commands to search for.


    Quick access toolbar example 1.4

  7. To add or remove the tools in the toolbar, select the command we have to insert at the left side window. Then, select “Add.” As a result, the chosen command will display in the right-side window. Then, click “OK” to finish the customizing process once we complete it.


    Quick access toolbar example 1.5

  8. If we have to reset all customizations, select the “Reset” icon, then select “OK” to customize the toolbar to default.


    Quick access toolbar example 1.6

  9. We can choose the customizations for a single workbook too. If we do not want other files to perform the customizations we selected, then select the “Customize Quick Access Toolbar” drop-down menu, then choose “XXXX” (filename) as shown below.


    Quick access toolbar example 1.7

Example #2 – Changing the Position of QAT

We can only place the toolbar in two positions: one at the top of the ribbon and the other at the top of the workspace area.

  • To replace the position of the toolbar, right-click on the drop-down icon and select “Show Below the Ribbon” to replace, as shown below.
Quick access toolbar example 2..1
  • Then, the status of the toolbar will change as below.
Quick access toolbar example 2.2
  • If we want to replace it with its default position, we must perform the same again. This time, it shows, as shown above, the ribbon.

Example #3 – Customizing the toolbar by Options Command

The steps to Customize the toolbar by Options Command are as follows:

  • Click the “File” tab, and then click “Options” to customize the toolbar in Excel.
Example 3.2
  • Then, click the “Quick Access Toolbar, and make the changes we want as we wish to ease access to the commands.
Example 3.3

Example #4 – Changing the Order of the Commands

The steps to Change the Order of the Commands are as follows:

  • Choose the left-click command on the QAT shortcut menu, then click more commands on the “Customize Quick Access Toolbar.”
example 4.1
  • Then, click the toolbar on the menu to replace the position of the commands for ease of access.
  • Under the “Customize Quick Access Toolbar”, click the command we want to move, then click move up or move down.
example 4.2
  • Then, click “OK” to see the customizations on our screen.
example 4.3

Example #5 – Export a Customized Quick Access Toolbar

We can export our ribbon and toolbar customizations into a file that can be imported and used by a team member on another PC.

  • Click the “File” tab. Then, under “Help,” click “Options,” click “Quick Access Toolbar.” Then, click “Import/Export” and “Export all customizations.”
example 5.1
  • Then, share the exported file with the user who wants to perform the customizations.

Important Things To Note

  • We can add multiple commands in this toolbar, but remember that it is a shortcut tool for simplifying the job. So, please do not choose the list of commands we use in long intervals, making it uncomfortable when we search for the command frequently.
  • We must use regular usage commands to display the same icons, which makes it easy to retrieve the command while using a file.

Frequently Asked Questions

1. Where is the Quick Access Toolbar found?

The Quick Access Toolbar is found on the left side of the Title Bar of any MS application window. It depends on the positioning, as shown in the images below.
At the top of the ribbon.

Quick Access Toolbar - Top

Below the ribbon, on top of the workspace area.

Quick Access Toolbar - below the ribbon

We can also hide the QAT as follows:
Right-click on the QAT – select the “Hide Quick Access Toolbar” option, as shown below.

Quick Access Toolbar - Hide

Then, the QAT is hidden, not seen anywhere on the ribbon, as shown below.

Quick Access Toolbar - Hidden

2. How to use the Quick Access Toolbar to sort numeric values?

For example, let us consider the data with numeric values given below.

Quick Access Toolbar - FAQ 2

First, click the “Customize Quick Access Toolbar” option drop-down, and select the “Sort Ascending option”, as shown below.

Quick Access Toolbar - Sort Ascending

The “Sort Smallest to Largest” button appears on the top of the Excel Ribbon, as shown below.

Quick Access Toolbar - Sort Smallest to Largest

Next, select the cell values from A2:A6, and click the “Sort Smallest to Largest” button on the ribbon.

Quick Access Toolbar - FAQ 2 - Output

We will get the above output, i.e., the numbers are now in ascending order.

3. Why is the Quick Access Toolbar in Excel not working?

A few reasons the QAT may not work are as follows:
The user might have changed his system and forgot to Import/Export the customized settings.
The QAT is hidden, so the options are not visible for usage.

This article is a guide to Quick Access Toolbar(QAT) in Excel. Here we add, move, customize QAT, import/export settings, examples, downloadable excel template. You may learn more about Excel from the following articles: –