The Quick Access Toolbar is a small customizable toolbar, located at the top of the application window. It is essential for efficient and personalized workflow. Users can customize it with frequently used commands, providing quick and consistent access to tools.
In this tutorial, you will learn 3 ways to show the Quick Access Toolbar in Excel using different Excel features.
You can see the Quick Access Toolbar in the image below, which can be enabled by following any of the ways discussed in this article.
Why Show Quick Access Toolbar in Excel?
The Quick Access Toolbar in Excel is a customizable toolbar providing quick access to frequently used commands and functions. Reasons to show the Quick Access Toolbar:
- Enables users to quickly access commonly used commands without navigating through multiple tabs in the Ribbon.
- Users can customize the toolbar to include specific commands relevant to their workflow, increasing efficiency and reducing the time spent searching for tools.
- The Quick Access Toolbar is user-specific, allowing individuals to set it up according to their preferences and work requirements.
- Customizing the Quick Access Toolbar provides a consistent set of tools that remain easily accessible regardless of the active Ribbon.
- For tasks that involve repetitive actions, having essential tools readily available on the Quick Access Toolbar can significantly streamline the workflow.
3 Ways to Show Quick Access Toolbar in Excel
To show the Quick Access Toolbar, you can use Excel features like: Ribbon Display Options, context menu of Ribbon, and Excel Options.
Here are the 3 ways to show the Quick Access Toolbar in Excel:
1. Applying Ribbon Display Options
You can apply the Ribbon Display Options to show the Quick Access Toolbar in Excel. The “Ribbon Display Options” is located at the bottom-right corner of the Excel Ribbon.
Steps to show the Quick Access Toolbar by applying Ribbon Display Options:
- Click on the Ribbon Display Options drop-down.
- Mark the Show Quick Access Toolbar option. Or press Alt + Z + R + S.
The Quick Access Toolbar is showing on the top of the worksheet.
2. Using the Context Menu of Ribbon
To show the Quick Access Toolbar in Excel, you can use the context menu of the Ribbon. You will get the context menus from the tab name area and commands section of the Ribbon which can be used to show the Quick Access Toolbar. The main advantage of this way is that you do not need to access any specific section in the ribbon. You can right-click anywhere in the ribbon to get the option to show the Quick Access Toolbar.
To show the Quick Access Toolbar using context menus of ribbon:
- Right-click on any tab of the Ribbon.
- Select the Show Quick Access Toolbar from the context menu.
Now, you will see the Quick Access Toolbar.
Alternatively, you can also right-click on any command under any tab in the Ribbon and select the Show Quick Access Toolbar for the same purpose.
Read More: Quick Access Toolbar is Missing in Excel
3. Using the Excel Options Feature
You can show the Quick Access Toolbar from the Excel Options window of the File tab.
Here are the steps to show the Quick Access Toolbar using Excel Options:
- Click on the File tab.
- Select Options to appear Excel Options window. Or press Alt + F + T.
- In the Excel Options window:
- Select the Quick Access Toolbar from the left side menu.
- Check the Show Quick Access Toolbar option from the right side.
- Finally, click on OK.
The Quick Access Toolbar is showing.
Conclusion
Displaying the Quick Access Toolbar in Excel is a handy way to access commonly used commands quickly. Whether you go with the default options or customize it to suit your needs, the toolbar is there to make your Excel experience more straightforward and efficient. We have explored 3 possible ways to show the Quick Access Toolbar in Excel in this article. Try the ways and inform us if you face any problems. For further queries write in the comment box.
Frequently Asked Questions
How to reset the Quick Access Toolbar to its default settings?
You can easily reset the Quick Access Toolbar to its default configuration by following:
- Go to the File tab > Options.
- In the Excel Options window: Quick Access Toolbar > Customizations.
- Under Customizations section: Reset only Quick Access Toolbar > OK.
Is the Quick Access Toolbar customizable?
Yes, it is customizable. You can customize it by adding or removing commands that are most relevant to your workflow.
Can you relocate the Quick Access Toolbar in Excel?
Yes, you can relocate it below or above the Ribbon based on your preference.