Search Contextures Sites

 

Contextures
Excel news
by email

We respect your email privacy

 

 

Learn how to create Excel dashboards.

Customize Quick Access Toolbar (QAT)

Related Excel VBA Tutorials

The Quick Access Toolbar (QAT) is displayed at the top of the Excel window, and comes with a few default commands installed. You can customize the QAT, adding more commands that you use frequently.

Add Close All and Exit to QAT

In Excel 2013, each file opens in its own window, and has its own Close button. To make it easier to close multiple windows quickly, you can add the Close All and Exit commands to the QAT.

Close All and Exit on QAT

Watch this video to see the steps.

Add a Macro to the Quick Access Toolbar

If you use an Excel command frequently, or if an Excel command isn't available on the Excel Ribbon, you can add its icon to the Quick Access Toolbar (QAT).

For example, here are the steps to add a macro to the QAT. The macro is named ToggleR1C1 and is stored in the Personal.xlsb file.

  • At the right end of the QAT, click the drop down arrow
  • Click More Commands

    QAT More Commands

  • In the Choose commands from drop down, click Macros

    QAT choose commands

  • In the list of macros, click the PERSONAL.XLS!ToggleR1C1 macro
  • Click Add, to move it to the Quick Access Toolbar

    QAT add macro

  • In the QAT list, click the PERSONAL.XLS!ToggleR1C1 macro
  • Click Modify, and click on an icon for the macro (I use the 8-ball), then click OK

    QAT modify button

  • Click OK, to close the Excel Options window.

The macro icon now appears on the QAT, and you can click it to run the macro.

Remove a Command from the QAT

If you no longer need an Excel command on the QAT, you can remove it. For example, here are the steps to remove a macro from the QAT.

  • On the QAT, right-click the command that you want to remove.
  • Click Remove from QAT

    QAT remove

The icon is removed immediately, without any confirmation message.

Watch the Customize QAT Video

To view the steps in a short video, click here:
Customize the Excel Quick Access Toolbar Video

 

Related Excel VBA Tutorials

  1. Excel VBA -- Adding Code to a Workbook
  2. Create an Excel UserForm
  3. Excel UserForm With ComboBoxes
  4. Excel VBA ComboBox Lists
 Learn how to create Excel dashboards.

 

 

 

Privacy Policy

 

Contextures Inc., Copyright ©2013
All rights reserved.

 

Last updated: May 21, 2013