How to Hide Ribbon in Excel (6 Simple Ways)

The Microsoft Excel ribbon is a row of tabs and icons at the top of the Excel window that lets you rapidly identify, understand, and utilize commands to complete a task. But, if you think this feature is taking up too many spaces in your worksheet, you can hide it with a few clicks. Let’s get familiar with some techniques on How to Hide Ribbon in Excel.


Download Practice Workbook


6 Ways to Hide Ribbon in Excel

This post will describe How to Hide Ribbon in Excel using the Display Ribbon Option, Shortcut technique, VBA, etc.


Method 1: Hide Ribbon in Excel Using Display Ribbon Option

Display Ribbon Option offers us three features to hide and unhide the ribbon tab.

Steps:

  • First, click on the Display Ribbon Option at the top right corner of the workbook.

How to Hide Ribbon in Excel

  • Now, three options will appear on the screen, if we click Auto-hide Ribbon, it will hide all the ribbon options.

  • Then to show the ribbons, click again on the Display Ribbon Option and select Show Tabs and Commands. Everything will be like before.

How to Hide Ribbon in Excel with ribbon display

  • In case, we want to hide all the ribbon commands and just ribbon tabs to show, then we have to choose Show Tabs.

  • And our workbook will be like the image below.


Method 2: Hide Ribbon by Collapsing Ribbon

Another option to hide the ribbon tab is the Collapse the Ribbon option.

Steps:

  • Just above the formula bar on the right side of the workbook, this upward arrow sign is available. Just click on the arrow sign.

How to Hide Ribbon in Excel with collapse ribbon


Method 3: Shortcut to Hide Menu Tab

We can also use a shortcut to hide ribbons in Excel. Just press CTRL+F1. In case you are using a laptop press CTRL+Fn+F1.

How to Hide Ribbon in Excel with Shortcut

To undo the method again press the shortcut key.


Method 4: Hide Ribbon in Excel Adding Quick Access

We can use a quick access toolbar at the top of our worksheet to hide ribbons in Excel.

Steps:

  • First, right-click on Collapse the Ribbon and click Add to Quick Access Toolbar.

How to Hide Ribbon in Excel with quick access toolbar

  • As a result, an option will appear at the top of the worksheet as a quick option. Clicking here will do what we need.


Method 5: Double Click and Hide Ribbon

We can also collapse the ribbon in Excel using a double click. Double click on any of the Ribbon Tab.

How to Hide Ribbon in Excel with double click


Method 6: Hide and Unhide Ribbon with VBA Macro

If you are a Macro lover, we also have a code for you.

Steps:

  • First, right-click on the sheet and go to View Code.

How to Hide Ribbon in Excel with vba

  • After that, copy and paste the VBA code below.

VBA Code:

Sub hide_Ribbon()

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"

End Sub

  • After that, press the F5 or play button to run the code.

This code will permanently hide the ribbon tab. To unhide the ribbon, we will have to use the following steps.

Steps:

  • Press ALT+F11 and go to Insert > Module.

How to Hide Ribbon in Excel with VBA Macro

  • After that, copy and paste the VBA code below.

VBA Code:

Sub hide_Ribbon()

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"

End Sub

  • After that, press the F5 or play button to run the code.

How to Hide Ribbon in Excel


Conclusion

That’s all for the article. These are 6 different methods on How to Hide Ribbon in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.

Tags:

Mahbub
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo