In this example we’ll assign a simple macro that auto adjusts the column width to the data in the sheet. See my post about creating a macro to make your own.

Step 1: Open the QAT options window.

Add a macro to the QAT.

Step 3: Assign your macro.

Select the Macro you want to add to the QAT.

Step 3: Run your macro from the QAT.

Now you will be able to run your macro easily from the QAT. If you forget what macro you’ve assigned to the QAT, you can hover your mouse cursor over the icon and the name of the macro will show.

Tip: You can also access the customization menu easily by right clicking anywhere on the quick access toolbar and selecting Customize Quick Access Toolbar.