Mahbubur Rahman
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.
- 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 Restore Ribbon in Excel (5 Quick Ways)
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.
Read More: How to Pin the Ribbon in Excel (4 Simple Methods)
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.
To undo the method again press the shortcut key.
Similar Readings
- How to Get Developer Tab in Excel (3 Quick Ways)
- [Fixed!] Excel Sheet Tabs Hidden behind Taskbar (4 Suitable Solutions)
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.
- As a result, an option will appear at the top of the worksheet as a quick option. Clicking here will do what we need.
Read More: How to Show, Hide, & Customize Excel Ribbon
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.
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.
- 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.
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.
