How to Hide Ribbon in Excel (6 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


This post will describe how to hide ribbons in Excel using the Excel Ribbon options, Shortcut technique, VBA, etc.

1. Using Display Ribbon Option to Hide Ribbon in Excel

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.

Read More: How to Show Menu Bar in Excel


2. Hiding Ribbon in Excel 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

Read More: How to Pin the Ribbon in Excel


3. Applying Keyboard 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.


4. Hiding 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.


5. Hiding Ribbon with Double Click in Excel

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


6. Running VBA Macro to Hide and Unhide Ribbon

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


Download Practice Workbook


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Mahbubur Rahman
Mahbubur Rahman

Mahbubur Rahman is a highly skilled and experienced professional with a strong background in both engineering and business administration. With an impressive technical skill set and a passion for innovation and problem-solving, Mahbubur has achieved great success in his field.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo