The Quick Access Toolbar is a small customizable icon on the worksheet’s upper-left side. It contains several commonly used commands.
Removing the Quick Access Toolbar in Excel can be helpful for different reasons. Taking away the toolbar gives more space for the main part of Excel. Moreover, some people change lots of things in Excel or use other toolbars a lot, so they might not need the Quick Access Toolbar.
In this Excel tutorial, you will learn 4 ways to remove the Quick Access Toolbar in Excel using different Excel features.
Take a look at a workbook before and after getting rid of the Quick Access Toolbar.
4 Ways to Remove Quick Access Toolbar in Excel
To remove the Quick Access Toolbar in Excel, you can use Excel features like Ribbon Display Options, context menus of Ribbon, Excel Options, and Customize Quick Access Toolbar.
Here are the 4 ways to remove the Quick Access Toolbar in Excel:
1. Applying Ribbon Display Options
To remove the Quick Access Toolbar, you can apply the Ribbon Display Options. You will get this option at the bottom right corner of the Ribbon area.
Steps to remove the Quick Access Toolbar by applying the Ribbon Display Options:
- Click on the drop-down icon of Ribbon Display Options.
- Check the “Hide Quick Access Toolbar” option. Or press Alt + Z + R + H.
The Quick Access Toolbar is no more showing.
2. Using Excel Ribbon Context Menu
To remove the Quick Access Toolbar, you can use the Ribbon context menu. Two context menus are available in the Ribbon area. They are: tab context menu and command context menu and both can be used to remove the Quick Access Toolbar. The main advantage of this method is that you can click anywhere in the ribbon area to avail of the context menu.
To remove the Quick Access Toolbar using the Ribbon context menu:
- Right-click after placing the mouse over any tab of the ribbon.
- Select the “Hide Quick Access Toolbar” of the context menu.
The Quick Access Toolbar is not showing now.
- Or, right-click on any command area in the Ribbon and choose “Hide Quick Access Toolbar” from the context menu.
3. Using Excel Options Feature
To remove the Quick Access Toolbar in Excel, you can use the Excel Options feature of the File tab.
Follow the steps to remove the Quick Access Toolbar using the Excel Options feature:
- 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 menu.
- Uncheck the Show Quick Access Toolbar option from the right side.
- Finally, click on OK.
Finally, the Quick Access Toolbar has been removed.
Read More: Quick Access Toolbar is Missing in Excel
4. Applying the Customize Quick Access Toolbar Feature
You can also remove the Quick Access Toolbar from the Customize Quick Access Toolbar drop-down menu.
To remove the Quick Access Toolbar from the Customize Quick Access Toolbar:
- Click on the drop-down icon of the Customize Quick Access Toolbar feature.
- Choose the “Hide Quick Access Toolbar” option.
The Quick Access Toolbar no longer exists.
Conclusion
Removing the Quick Access Toolbar in Excel is easy and improves your workspace by eliminating unnecessary elements. This customization frees up space and makes Excel more user-friendly and efficient for your specific needs. Here, we have explored 4 different ways to remove the Quick Access Toolbar in Excel. Apply the discussed ways and write in the comment box for further queries.
Frequently Asked Questions
Yes, you can share your customized Quick Access Toolbar settings with others using the export option.
- Go to File tab > Options.
- In the Excel Options window: select Quick Access Toolbar > Customizations.
- Under the Customizations section: Import/Export drop-down > Export all Customizations.
- Then save the file in File Explorer in the Exported Office UI file format.
Where is the Quick Access Toolbar in Excel located?
The Quick Access Toolbar is located at the upper-left corner of the Excel worksheet. Associated commands are also shown with the Quick Access Toolbar.
What are the default commands of the Quick Access Toolbar?
The Quick Access Toolbar contains 3 default commands and those are: Save, Undo, and Redo.
Relates Article
<< Go Back to Quick Access Toolbar in Excel | Excel Parts | Learn Excel