The toolbar in an Excel worksheet exists on the top of the Excel window. The Quick Access Toolbar is actually a combination of different tabs and commands in order to execute any task quickly. But you can also remove the quick access toolbar from the window. If you need to do so, then you have landed in the right place. In this article, I will show you how to remove the quick access toolbar in Excel.
Download Practice Workbook
You can download the practice book from the button below.
3 Ways to Remove Quick Access Toolbar in Excel
In this section, you will find 3 easy and quick ways to remove the quick access toolbar. Let’s check them now!
1. Use Ribbon Display Options
You can remove the quick access toolbar by using the Ribbon Display Options located at the right-top corner of the Excel window. In order to do so, proceed with the following steps:
- First of all, click on the Ribbon Display Options icon at the right-top corner of the worksheet.
- Then, it will show 3 options. Now, click the Auto-hide Ribbon.
- Hence, you will get the Quick Access Toolbar hidden.
- Again, you can show it by clicking the Show Tabs and Commands option.
- Here, you can also unhide the toolbar by clicking the three dots (as in the screenshot below)
2. Hide Commands from Quick Access Toolbar
In this section, we will see how to hide only the commands toolbar keeping the tabs on the ribbon. There are several tricks for doing so. Let’s demonstrate them one by one.
2.1. Using Keyboard shortcut
We will now see the use of a keyboard shortcut to remove the quick access toolbar. For this, follow the steps below.
- Here, the toolbar contains the command. All you have to do is to press CTRL+F1.
- As a result, Excel will remove the commands from the ribbon and only show the tabs.
You can remove toolbar in the blink of an eye in this way!
2.2. Double Click on Any Tab
You can also remove the quick access toolbar by using this method. Just follow the steps below for doing this.
- Here, all you have to do is just double-click on any of the tabs like the screenshot below.
- Hence, your commands will be gone.
So easy, isn’t it?
2.3. Adding “Collapse the Ribbon”
You can also remove the toolbar by adding “Collapse the Ribbon” option. Proceed as below for doing so.
- Firstly, click on the Collapse the Ribbon option at the right corner of the window.
- Then, 3 options will appear. Choose the Add to Quick Access Toolbar option from the list.
- Hence, your Collapse the Ribbon option will show up on the toolbar.
- Now, just click on this option and the ribbon will hide the command toolbar.
3. Using VBA to Remove Quick Access Toolbar
Let’s use VBA to remove the Quick Access Toolbar. In order to do so, follow the steps below:
- Firstly, press ALT+F11 to open the VBA editor.
- Then, right-click on your worksheet> choose Insert> click Module.
- After that, the Module window will show up. Enter your VBA code here. You can use the following:
Option Explicit Sub remove_toolbar() Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)" End Sub
- Now, save this file as Macro-enabled Workbook. Press ALT+Q to close the window.
- After that, Excel will return you to the worksheet. Now, press ALT+F8 to open the Macro dialogue box. Here, select the Macro name (i.e. remove_toolbar) and click Run.
- As a result, you will get the Quick Access Toolbar removed.
In this way, you can apply VBA to remove your Quick Access Toolbar.
In this article, you have learned how to remove quick access toolbar in Excel. I hope from now on you can easily remove the quick access toolbar in an Excel workbook. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy. Have a great day!