Part 2/8:
Many Excel users fall into one of three categories concerning the QAT:
Using it, but not to its full potential.
Adding the wrong shortcuts, thus wasting valuable real estate.
Ignoring it altogether.
Even advanced users often overlook this feature, but customizing it can save significant time. To customize the QAT, click the small down arrow to the right of the toolbar, which provides a drop-down list of common commands. Additionally, you can right-click on any command in the ribbon to add it directly to your QAT.
Adding and Removing Commands
To add a command, right-click on it in the ribbon and choose "Add to Quick Access Toolbar." If needed, commands can also be removed by right-clicking on them from the QAT.