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 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.
Bring Back Excel Ribbon If It Keeps Disappearing: 5 Possible Ways
It can happen that the ribbon gets hidden or disappears 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.
- In the beginning, press CTRL + F1.
- Therefore, the ribbon appeared properly with all tabs and ribbon commands.
Read More: How to Pin the Ribbon in Excel
2. Double-Clicking on Any Tab Names
You can also easily display the ribbon by double-clicking any of the tab names.
- First of all, I have double-clicked on the Home tab.
- Hence, I can see the ribbon is displayed.
3. Use of Ribbon Display Options to Display Ribbon in Excel
In this method, I will use the Ribbon Display Options to bring back and show the ribbon in Excel. Follow the steps to view the Excel ribbon:
- 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: How to Show Menu Bar in Excel
4. Unchecking “Collapse the Ribbon” Option
Another quick method is to uncheck the “Collapse the Ribbon” option.
- 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.
5. Ending Full-screen Mode
While working on an Excel file, you can mistakenly activate the Auto-hide Ribbon to hide the 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 solution 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: What Is Contextual Tab in Excel?
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.
On the Practice Section worksheet, you will find a dataset to practice independently.
Download Practice Workbook
You can download the practice workbook here.
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.