Rabeya Islam
Excel ribbon is like a navigation tool for the whole Excel workbook. One can access and use excel features using the ribbon tabs. So, it is mandatory to have the excel ribbon displayed while working on excel. But, if anyhow the excel ribbon keeps disappearing or is not showing up, you can follow the methods written in this tutorial to easily get back your excel ribbon in a minute.
In the following GIF, you can see the overview of getting back the Ribbon when it keeps disappearing. Let’s dive into the following article to do the task.
Download Practice Workbook
You can download the practice workbook here.
5 Possible Ways to Bring Back Excel Ribbon If It Keeps Disappearing
It can happen that the ribbon got hidden or disappeared because of any issues. We can easily bring it back with one or two mouse clicks. Here, I have an excel file (containing the order list of a company) that does not show the excel ribbon. I will show some easy ways to again display the ribbon. You can use any of the methods. In this tutorial, I used the Microsoft Excel 365 version.
1. Using Keyboard Shortcut to Bring Back Excel Ribbon
You can easily bring the excel ribbon back using the keyboard shortcut.
Steps:
- In the beginning, press CTRL + F1.
- Therefore, the ribbon appeared properly with tabs and commands.
Read More: How to Show Ribbon in Excel (5 Quick & Simple Ways)
2. Double-Clicking on Any Tab Names
You can also easily display the ribbon by double-clicking any of the tab names.
Steps:
- First of all, I have double-clicked on the Home tab.
- Hence, I can see the ribbon is displayed.
Read More: MS Excel Ribbon and Its Function
Similar Readings
- How to Add Data Types to Ribbon in Excel (With Quick Steps)
- [Solved]: Data Types Stocks and Geography Missing Problem in Excel (3 Solutions)
- How to Display Developer Tab on the Ribbon in Excel
- What Is Contextual Tab in Excel? (With Easy Examples)
3. Use of Ribbon Display Options to Display Ribbon in Excel
In this method, I will use the Ribbon Display Options to bring back the ribbon. Follow the steps to view the excel ribbon:
Steps:
- First, find the up arrow looking option from the right top of the excel file.
- Afterward, three options will be shown.
- Then, select Show Tabs and Commands option.
- As a result, the ribbon is back easily.
Read More: Ribbon Commands in Excel (Detailed Explanation)
4. Unchecking “Collapse the Ribbon” Option
Another quick method is to uncheck the “Collapse the Ribbon” option.
Steps:
- First, Right-Click on any of the tab names. I will click on the Home tab.
- Then, two options will appear.
- Moreover, uncheck “Collapse the Ribbon“.
- After this, the worksheet will look like this.
Read More: [Fixed!] Excel Sheet Tabs Hidden behind Taskbar (4 Suitable Solutions)
5. Ending Full-screen Mode
While working on an excel file, you can mistakenly activate the Auto-hide Ribbon or anyhow enter the full-screen mode. That will lead the worksheet to look like the following image. Again, there are two temporary and one permanent solutions for this issue.
- After that, to end the full-screen mode, you can click on the top of the worksheet.
- Another temporary and quick solution is that you can also use the keyboard shortcut CTRL+SHIFT+F1.
- In order to get a permanent solution to bring back the ribbon, use “Ribbon Display Options” from the above-mentioned method.
- Therefore, it will bring back the ribbon.
Read More: How to Hide Ribbon in Excel (6 Simple Ways)
Things to Remember
- You can apply the methods in any order.
- If any of the methods do not work, you can try uninstalling excel from your PC and installing the latest version.
Practice Section
On the Practice Section worksheet, you will find a dataset to practice independently.
Conclusion
In this tutorial, you learned to fix the issue of the excel ribbon disappearing. Follow our ExcelDemy page for regular blogs related to Excel. You can suggest your thoughts about this article in the comment section below.
