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