Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Remove Quick Access Toolbar in Excel (3 Easy Ways)

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:

Steps:

  • First of all, click on the Ribbon Display Options icon at the right-top corner of the worksheet.

Remove Quick Access Toolbar in Excel

  • Then, it will show 3 options. Now, click the Auto-hide Ribbon.

Remove Quick Access Toolbar in Excel

  • Hence, you will get the Quick Access Toolbar hidden.

Remove Quick Access Toolbar in Excel

  • Again, you can show it by clicking the Show Tabs and Commands option.

Remove Quick Access Toolbar in Excel

  • Here, you can also unhide the toolbar by clicking the three dots (as in the screenshot below)

Read More: How to Add the Fill Color Icon to the Quick Access Toolbar in Excel


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.

Steps:

  • 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.

Remove Quick Access Toolbar in Excel

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.

Steps:

  • 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.

Remove Quick Access Toolbar in Excel

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.

Steps:

  • Firstly, click on the Collapse the Ribbon option at the right corner of the window.

Remove Quick Access Toolbar in Excel

  • 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.

Read More: [Fixed!] Quick Access Toolbar in Excel Missing


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:

Steps:

  • 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.

Remove Quick Access Toolbar in Excel

In this way, you can apply VBA to remove your Quick Access Toolbar.

Read More: How to Add a Macro to Your Quick Access Toolbar in Excel


Conclusion

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!


Related Articles

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo