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.
- Now, choose Show Tabs and Commands from the menu.
- You will instantly see the ribbon including all the features on it.
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.
- By clicking on any tab you will see the ribbon for some time. The temporary ribbon icon will appear at the bottom right side.
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.
- Now, you will see tab names individually.
- The previously hidden tab options will start appearing on the ribbon by clicking on the tab name one by one.
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.
How to Show Excel Ribbon with Keyboard Shortcut
Suppose that the tabs are visible on the Excel sheet.
For this, press CTRL + F1 to appear the ribbon.
How to Show Ribbon in Full-Screen Mode
It often happens that the Excel top area looks green just as in the image below.
- 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.
