Search Contextures Sites
- Add Close All and Exit to QAT
- Add a Macro to the Quick Access Toolbar
- Remove a Command from the QAT
- Watch the Customize QAT Video
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.
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.
Watch this video to see the steps.
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
- In the Choose commands from drop down, click Macros
- In the list of macros, click the PERSONAL.XLS!ToggleR1C1 macro
- Click Add, to move it to the Quick Access Toolbar
- 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
- 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.
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
The icon is removed immediately, without any confirmation message.
To view the steps in a short video, click here:
Customize the Excel Quick Access Toolbar Video
Related Excel VBA Tutorials
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 21, 2013