How to Show Ribbon in Excel (5 Quick & Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates 5 easy ways to show the ribbon in Excel. You may accidentally hide the ribbon in Excel. If you are wondering about how to make it visible again then this article will help you to do that. We can easily access the commands from the Excel ribbon. But, it occupies a significant portion of the screen. So, one can purposefully hide the ribbon to gain more screen space when the only concern is to show the data. Have a quick look through the article to learn the ways you can unhide the ribbon again.


1. Applying Keyboard Shortcut to Show Excel Ribbon

Assume, that only the tabs are visible in your Excel as shown below.

Now, press CTRL+F1 to make the ribbon visible.

Read More: MS Excel Ribbon and Its Function


2. Showing Ribbon Using Ribbon Display Options

Alternatively, you can select any tab. Then, the ribbon will be visible temporarily. If you click away the ribbon will be hidden again.

After the ribbon is temporarily visible, you will see a downward arrow at the lower right corner of the ribbon. This is the icon for the Ribbon Display Options. Now, click on it.

Next, you will see that there is a checkmark at the left of the Show tabs only option.

Now, click on the Always show Ribbon option to make the ribbon permanently visible.

Show Ribbon in Excel Using Ribbon Display Options


3. Displaying Ribbon by Unselecting Collapse Ribbon Option

If only the tabs are visible then right-click on the tab area. Then you will see a checkmark at the left of the Collapse the Ribbon option.

Click on it to uncheck it. Then the ribbon will be visible again.

Show Ribbon in Excel by Unchecking Collapse the Ribbon

Read More: Ribbon Commands in Excel


4. Showing Ribbon in Full-Screen Mode

Sometimes the top of your Excel may look like the following. Only a green bar is visible at the top of the Excel window.

Now, click on the green bar at the top. This will make the ribbon visible again temporarily. Next, click on the Ribbon Display Options icon at the lower right corner of the ribbon. Then, you will see that the Full-screen mode is on. After that, click on the  Always show Ribbon option.

Read More: How to Show Menu Bar in Excel


5. Using Excel Settings to Show Ribbon

You can also make the ribbon visible from Excel Options. Press ALT+F+T to open the Excel Options window. Then find the User Interface option named Collapse the Ribbon automatically from the General tab. Then, uncheck the option and click OK.

Show Ribbon Using Excel Options


Things to Remember

  • These methods only work if the Excel Ribbon is hidden.
  • You can use the keyboard shortcut repeatedly to show or hide the ribbon.

Download Practice Workbook

You can download the practice workbook from the download button below.


Now you know how to show the ribbon in Excel in 5 different ways. Please let us know if this article has helped you with your problem. You can also use the comment section below for further queries or suggestions. Do visit our ExcelDemy blog to explore more on Excel. Stay with us and keep learning.


Related Articles


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

Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo