Contextures

Customize Quick Access Toolbar

The Quick Access Toolbar (QAT) is at the top of the Excel window, and comes with a few default commands installed. See how to customize the QAT, and add macros or favorite commands.

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).

Quick Access Toolbar icon

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.

macro icon on the QAT

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 see the steps watch this short video

Related Excel VBA Tutorials

Adding Macro Code to a Workbook

Create an Excel UserForm

Excel UserForm With ComboBoxes

Excel VBA ComboBox Lists

Search Contextures Sites

 

Excel Tools Add-in

 

 

Excel UserForms for Data Entry

 

 

 

 

Excel Data Entry Popup List

 

Last updated: December 22, 2016 12:30 PM
Contextures RSS Feed