How to Hide Toolbar in Excel (3 Quick Methods)

In this article, I will discuss how you can hide the Toolbar (Ribbon) in excel. The Excel Toolbar is located on the top of the excel window and contains a combination of tabs and commands to perform different tasks. While working in Microsoft Excel, often we need to hide the Ribbon to accommodate more space for a spreadsheet. Besides, you may need to hide the Ribbon to avoid unwanted operations in excel.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


3 Quick Methods to Hide Toolbar in Excel

I will explain three easy and quick methods to hide Excel Ribbon. Let’s go through the article to learn about the methods.

1. Use ‘Ribbon Display Options’ to Hide Toolbar in Excel

You can hide the Ribbon using the ‘Ribbon Display Options’ icon located in the top right corner of the excel window.

Use ‘Ribbon Display Options’ to Hide Toolbar in Excel

Follow the steps to hide the excel toolbar.

Steps:

  • Initially, click on the ‘Ribbon Display Options’ icon.
  • As a result, the below menu appears. Now click on the Auto-hide Ribbon option to hide the Excel Ribbon completely.

Use ‘Ribbon Display Options’ to Hide Toolbar in Excel

  • Consequently, you will see that the Ribbon is hidden from the Excel window as shown in the below screenshot.

Use ‘Ribbon Display Options’ to Hide Toolbar in Excel

Note:

  • You can display the Excel Ribbon by clicking on the three dots located in the top right corner of the excel window (next to Ribbon Display Options). Or you can press the Alt key from the keyboard to go to any tabs.

  • You can again show the excel Ribbon by clicking on the Ribbon Display Options and choosing any of the options shown below.

Read More: How to Show Toolbar in Excel (4 Simple Ways)


2. Excel VBA to Hide Toolbar in Excel

If you want to prevent any operations by an unauthorized person, you can hide the Excel Toolbar/Ribbon completely using Excel VBA. Let’s follow the below steps to get the task done.

Steps:

  • First, open the excel file and go to Developer > Visual Basic. Or you can use Alt + F11 to bring the VBA window.

Excel VBA to Hide Toolbar in Excel

  • When the VBA window shows up, go to Insert > Module.

Excel VBA to Hide Toolbar in Excel

  • Now, type the below code in the newly inserted Module.
Option Explicit
Sub hide_toolbar()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
End Sub

Excel VBA to Hide Toolbar in Excel

  • Then, come back to the excel main window and go to Developer > Macro. Alternatively, you can press Alt + F8 to bring the Macro dialog.

Excel VBA to Hide Toolbar in Excel

  • When the Macro dialog comes up, select the Macro Name: hide_toolbar and press Run.

Excel VBA to Hide Toolbar in Excel

  • Upon running the Macro, the toolbar is gone from the Excel window (see the screenshot).

Note:

If you want to show the toolbar again, use the below code:

Sub show_toolbar()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"
End Sub

Read More: Types of Toolbars in MS Excel (All Details Explained)


3. Hide Commands from Excel Toolbar

In this method, I will show how you can hide commands from the excel Toolbar. There are several ways to perform the task. Let’s explore them one by one.

3.1. Using Keyboard Shortcut

First of all, I will hide commands from Excel Ribbon using keyboard shortcuts.

Steps:

  • Simply click Ctrl + F1, keeping the tabs and commands visible.

Hide Commands from Excel Toolbar

  • As a result, you can see that only tabs are visible. All the commands have become hidden.

Hide Commands from Excel Toolbar

Note:

You can hide commands from excel Toolbar by clicking on the Collapse the Ribbon icon located in the top right corner of the Excel window (see screenshot).


3.2. Double-Clicking on Excel Tabs

Another easy way to hide commands from the excel Toolbar is to double-click on tabs.

Steps:

  • Go to Excel Ribbon and double click on any tab (say Home tab).

Hide Commands from Excel Toolbar

  • As a result, the commands will become invisible, and tabs remain only.


3.3. Adding ‘Collapse the Ribbon’ to Quick Access Toolbar

You can add the Collapse the Ribbon option to the Quick Access Toolbar and later click on the added icon to hide commands from excel Toolbar.

Steps:

  • Firstly, go to the Excel Ribbon, and right-click on the Collapse the Ribbon icon.
  • Next, the below menu will appear.
  • Click on the Add to Quick Access Toolbar option.

Hide Commands from Excel Toolbar

  • Subsequently, the Collapse the Ribbon option will be added to the Quick Access Toolbar.
  • Now, when you have to hide commands from the toolbar, simply click on the newly added icon.

Hide Commands from Excel Toolbar

  • Finally, we can see all the commands hidden, thus tabs are visible only.

Read More: How to Add Strikethrough in Excel Toolbar (3 Easy Ways)


Conclusion

In the above article, I have tried to discuss several methods to hide the Toolbar in excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo