Excel Effects

Reference guide.

Add or remove items from the Quick Access Toolbar – Quick tip

Add or remove items on the quick access toolbar - Quick tip

So, this super quick tip shows you how to add or remove items from the quick access toolbar (or QAT). All in all, this lesson applies to versions of Office that have a QAT.

Overall, the QAT allows us to access commands that we use frequently. It is located either above or below the ribbon.


Click right-click

We use the right-click button often in this lesson. Moreover, it allows us to access shortcut menus and quickly display dialog boxes.


Show QAT above or below the ribbon

Before we get started, you may want to know how to show the QAT above or below the ribbon. Personally, we prefer below the ribbon. So, here is how to do it.

Above the ribbon

Steps to put the QAT above the ribbon

  1. Right-click on a gray area of the QAT. The shortcut menu appears.
    Note: It can be difficult finding a gray area on the toolbar. However, just keep trying.
  2. From the shortcut menu, select Show Quick Access Toolbar Above the Ribbon.

As a result, the QAT will appear above the ribbon, as part of the title bar.

QAT above the ribbon

Below the ribbon

Follow the same steps to put it back below the ribbon. However, you will select Show Quick Access Toolbar Below the Ribbon from the shortcut menu.

Now, we can get down to business.


Steps to add or remove items from the quick access toolbar

Follow the steps below to add or remove items from the QAT.

Customize Quick Access Toolbar

  1. Right-click on a gray area of the QAT. The shortcut menu appears.
  2. Under the shortcut menu, select Customize Quick Access Toolbar... The Excel Options dialog box opens.

Excel Options - Customize the Quick Access Toolbar

  1. Select the command you want to add or remove. So, commands on the left-side are ones you want to add. And, commands of the right-side are ones you want to remove.
  2. After selecting your command, press Add >> or << Remove.
  3. Press OK.

Quickly remove a command from the Quick Access Toolbar

So, you do not need to go through the above steps if you just want to remove an item from the QAT.

Remove a command from the Quick Access Toolbar.

If you want to quickly remove a command from the QAT, then (1) right-click on a command and select (2) Remove from Quick Access Toolbar.


Quick Access Toolbar success!

So, were you successful? If not, then give it another shot.


Additional resources

Below are additional resources to this quick tip.


Add or remove items from the quick access toolbar
by Excel Effects :: October 26, 2020


Online courses Home

Techronology

Artplotty Grid

Development Category (English)300x250

Microsoft Surface Book 3