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.
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.
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.
The icon is removed immediately, without any confirmation message.
To see the steps watch this short video
Last updated: December 22, 2016 12:30 PM
Contextures RSS Feed