Macros in Word and Excel provide the ability to save time on predictable, repetitive tasks. You can and then simply click a button to run the macro and perform the task. Once you’ve recorded your macro (see our article at the above link), you can add a button to the Quick Access Toolbar so you can quickly run the macro. To do this, click the down arrow button on the right side of the Quick Access Toolbar and select “More Commands” on the popup menu. The “Excel Options” dialog box displays with the “Customize the Quick Access Toolbar” screen active. Select “Macros” from the “Choose commands from” drop-down list. Select the macro you want from the list below the “Choose commands from” drop-down list and then click “Add”.
![Customize Quick Access For Excel For Mac Customize Quick Access For Excel For Mac](/uploads/1/2/5/6/125600480/793536601.jpg)
The Quick Access Toolbar can be customized to add almost any Excel Command. I’ll cover how to customize the Excel UI in a later post. You’ll also find the Filename, Search Box and Sharing Options icon in this region. Click on commands under the Customize Quick Access Toolbar section. Click on the Up or Down arrows to the right on the command list to move the command up (left) or down (right). Click Ok to complete.
The macro is added to the “Customize Quick Access Toolbar” list. Click “OK” to accept the change and close the “Excel Options” dialog box. Macros can be recorded in Word and Excel.
We showed you how to add a macro to the Quick Access Toolbar in Excel 2016, but this procedure will also work in Excel 2013 and Word 2013 and 2016. NOTE: Macros are essentially bits of computer code and are potentially dangerous. For more information, see our article about.
Check out my Blog: Do you know QAT? No, it's not a duck call!
It's the Quick Access Toolbar! It's the tiny sliver of real estate on the very top of Excel. Usually it has small icons like a floppy drive or a folder. If you are the type of person that likes to customize something to work in your own personal way or you are a control freak, then you will like the QAT. Think of it as a quick way to access commands that you perform often.
![Access Access](/uploads/1/2/5/6/125600480/400033442.jpg)
Or if those commands usually take too many mouse clicks to get to you can put it onto the QAT! Its saves time and it's your own personal piece of space in Excel.
Check out the video to learn to how it works.