[Fixed] Excel Ribbon Keeps Disappearing (5 Easy Solutions)

Get FREE Advanced Excel Exercises with Solutions!

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.

overview for the solution of ribbon disappearing


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.

Dataset


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.

Excel file without commands

  • Therefore, the ribbon appeared properly with all tabs and ribbon commands.

Excel ribbon appeared with crtl+F1

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.

Steps:

  • First of all, I have double-clicked on the Home tab.

Double-clicking on any tab names to appear the ribbon

  • Hence, I can see the ribbon is displayed.

final look with the ribbon


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:

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.

Ribbon Display Options to display ribbon

  • As a result, the ribbon is back easily.

excel file with ribbon

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.

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

unchecking Collapse the Ribbon

  • After this, the worksheet will look like this.

excel ribbon appeared


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.

Full-screen Mode

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

ending the Full-screen Mode by clicking the top of the worksheet

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.

Practice Section

On the Practice Section worksheet, you will find a dataset to practice independently.

Practice Section to solve the ribbon disappearing issue


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.


<< Go Back to Excel Ribbon | Excel Parts | Learn Excel

What is ExcelDemy?

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

Tags:

Rabeya Islam
Rabeya Islam

Rabeya Islam, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the SOFTEKO for more than one and half years. She has written some articles for ExcelDemy. Currently, she is working as the team leader, oversees the day-to-day work, and leads the SQA team Excel Extensions project. She has built the workflow and the structure of the extension testing for the team. Her work and learning interests vary from Microsoft Office Suites, VBA, and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo