Quick Access Toolbar
The Quick Access Toolbar (QAT) is a customizable toolbar that consists of a set of commands such as Save, Undo, and Redo at the top-left corner of your Excel screen.
Table of Contents
Why Use the Quick Access Toolbar?
Below are a few reasons why you should consider using the Quick Access Toolbar:
- Saves Time: No more going through multiple tabs to search for a command. With the QAT, your most used command can be just one click away.
- Customization: You can add commands that are not available by default in the Ribbon providing a personalized experience and also remove any command.
- Consistency Across Workbooks: Once you customize the QAT, it remains the same across all your Excel workbooks giving a consistent workspace.
How do you Customize the Quick Access Toolbar?
Follow these simple steps to customize your Quick Access Toolbar:
- Access the Toolbar menu: Click on the drop-down arrow at the end of QAT which contains a list of popular commands suggested by Excel.
- Simply check or uncheck the commands to add or remove them from your toolbar such as Sorting the data to ascending or descending, Email the current workbook in just one click, Spell check your data and Print Preview your worksheet.
- Explore More Commands: To add commands that are not listed in the default list, you can always click on More Commands at the bottom of the menu.
- A new window will be opened which allows you to explore all commands in Excel from basic to advanced.
- Select a command as per your requirement which is displayed in the left pane and click on Add to insert it into your Quick Access Toolbar.
Pro Tip: Check out our detailed guide on Customizing and resetting the Excel Ribbons to fully optimize your Excel workspace.
Additional Tips to Customize Your Quick Access Toolbar
- If you use VBA macros, you can add them to the QAT for quick access.
- By default, the QAT is located at the top left corner of Excel (above the Ribbon), but you can easily move it below just by selecting the option from the drop-down menu.
Conclusion
The Quick Access Toolbar is a simple but powerful feature in Excel that increases your productivity. It allows you to customize it as per your needs and reduce repetitive tasks. Start customizing your QAT today and see the difference it makes!