Excel Show Ribbon – How to Show Ribbon in Excel

  • Home
  • / Excel Show Ribbon – How to Show Ribbon in Excel

The ribbon is the most used area of the Excel screen because you will find many features from there. Sometimes, you might feel that the Excel ribbon has covered enough space on the screen that’s why you hide it anyway. If the ribbon is already hidden and you are unable to find it after many trials you tend to get frustrated. However, it is quite a simple task but for some users, it may demand effort and time.

Let’s see how you can appear the Excel ribbon easily.

How Excel Show Ribbon Quickly

When the ribbon is not visible and you want to make it appear on the screen below is the procedure:

  • In the upper right side, click on the icon containing an arrow pointing upside. This icon is used for Display Ribbon Options.

how to show ribbon in excel

  • Now, choose Show Tabs and Commands from the menu.

how to show ribbon in excel2

  • You will instantly see the ribbon including all the features on it.

how to show ribbon in excel3

How to Show Collapsed Ribbon in Full View

In case when the Excel ribbon is not appearing and the tab names are highlighted only, you can follow the given procedure to get back to the normal display.

  • Press CTRL + F1 shortcut for ribbon.
  • By double-clicking on the ribbon tab you can visible the entire ribbon.
  • Clear the check box by right-clicking any ribbon tab. choose Collapse the Ribbon in Excel 2019-2013 or else you can Minimize the Ribbon in Excel 2010 and 2007.

show collapsed ribbon

  • By clicking on any tab you will see the ribbon for some time. The temporary ribbon icon will appear at the bottom right side.

show collapsed ribbon2

How to Show Ribbon Tabs Only

When you need to see the ribbon tabs only, you have to click on the Ribbon Display Options icon and choose Show Tabs.

show ribbon tabs only

  • Now, you will see tab names individually.

show ribbon tabs only2

  • The previously hidden tab options will start appearing on the ribbon by clicking on the tab name one by one.

show ribbon tabs only3

You can hide these tabs once again by clicking anywhere in the sheet while picking the required function. You will only see the names this time.

show ribbon tabs only4

How to Show Excel Ribbon with Keyboard Shortcut

Suppose that the tabs are visible on the Excel sheet.

show excel ribbon shortcut

For this, press CTRL + F1 to appear the ribbon.

show excel ribbon shortcut2

How to Show Ribbon in Full-Screen Mode

It often happens that the Excel top area looks green just as in the image below.

show ribbon full screen

  • When you click on the green bar you will see the ribbon visibility for some time. Now, at the bottom right side of the screen, you will see the Ribbon Display Options, click on it.
  • Once it is done, the Full-screen mode will be activated.
  • Now, click on the Always show Ribbon option.

How to Show Excel Ribbon with Excel Settings

Using the Excel Options, you can make the Excel ribbon appear. For this, press ALT + F + T and it will open up the Excel Options. Now, choose the User Interface option visible as Collapsed the Ribbon automatically given in the General tab. uncheck the option and click OK.

Things to Remember

  • All the above-mentioned methods are effective only when the Excel Ribbon is hidden.
  • The given shortcut can be used repeatedly to hide or unhide the ribbon.

Final Thoughts

You are now aware of how Excel shows ribbons by using different methods. You can try any of the above methods and each method is super effective because of its significance. Keep trying and continue exploring Excel.

Write your comment Here