TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON 29 Customizing the Quick Access Toolbar

 

Customizing the Quick Access Toolbar

In order to improve your workflow, you would like to add some of your most frequently used commands to the Quick Access toolbar.

1. To begin, open a blank workbook in Microsoft 365 Excel:

2. Click File → Options:

3. The Excel Options dialog box will open to the General category:

4. Click the Quick Access Toolbar category:

5. The Quick Access Toolbar category will now be displayed:

6. In the left-hand list box, scroll down and click to select the Repeat command:

7. Click the Add command between the two lists:

8. The Repeat command will now appear in the right-hand list box, meaning it has been added to the Quick Access toolbar:

9. Click OK to apply these new settings:

10. Returning to the Excel window, you will see that the Repeat command now appears on the Quick Access toolbar:

11. You can now close Microsoft 365 Excel to complete this activity.