

Likewise if you are adding macros that are in your Personal.xlsb, you can stay with this option. If you are adding standard Excel commands then leave this option on For all documents (default). It is here that you can also choose to add macros.Īs this is what I want to do, I am going to click on Macros.Īnd I now see a list of the macros available to me.Īny commands or macros you add to the QAT can be made available either to all Excel documents (which is the default), or just for the workbook you currently have open. You can click on the drop-down list under Choose commands from to select where you want to add commands from. The window that appears allows you to choose commands from the list on the left hand side of the main pane, and add them to the QAT by clicking on the Add> button. Right click your mouse anywhere on the QAT or the Ribbon, and from the menu that appears, click on Customize Quick Access Toolbar. You can also modify the Ribbon to show custom tabs, groups and icons for your own macros and commands. Just follow the 8 steps below, it shouldn't take you more than 5 minutes, if that. You can customize the Quick Access Toolbar (QAT) in Excel so that you add icons to run your macros, or commonly used tasks and tools.

Excel for Customer Service Professionals.
