How to Show or Hide the Ribbon in Excel (Quick and Easy)

How to Show or Hide Ribbon in Excel

Today we’ll have a look at how to show or hide the ribbon in Excel. And you’ll see – it’s no rocket science.

Let’s get started!

Would you rather watch this tutorial? Click the play button below!

What Is the Ribbon in Excel and Where to Find It

The Ribbon in Excel is the display you see at the top of the Excel window, through which you can access Excel commands and functions.

How to Show or Hide the Ribbon in Excel - The Ribbon in Excel

How to Show the Ribbon in Excel

If it’s hidden and you want to see it, click on the icon in the top right-hand corner, the one with an arrow pointing up, which is the icon for Ribbon Display Options.

How to Show or Hide the Ribbon in Excel - Ribbon Display Options

From the menu that appears, select ‘Show Tabs and Commands’.

How to Show or Hide the Ribbon in Excel - Show Tabs and Commands

Excel will immediately show the ribbon with all the functions Excel offers when the display is set on standard.

How to Show or Hide the Ribbon in Excel - The Ribbon in Excel

How to Hide the Ribbon in Excel

Now let’s have a look at the other two options how you can make your working area in the spreadsheet larger.

To see all Ribbon Display Options again, click on the arrow icon on the right at the top of the screen.

How to Show or Hide the Ribbon in Excel - Ribbon Display Options

Let’s select the first option, ‘Auto-hide Ribbon’, and let’s see what happens now.

How to Show or Hide the Ribbon in Excel - Auto Hide Ribbon

This option hides the ribbon, but once we need it, we can always ‘call’ it by clicking into the bar located at the top of the window.

How to Show or Hide the Ribbon in Excel - Clicking into the bar located at the top of the window

The ribbon will appear and you’ll be able to choose whichever function you need.

How to Show or Hide the Ribbon in Excel - The Ribbon in Excel

Then you click anywhere within the spreadsheet area and the ribbon will disappear again. Once it’s not visible, you can work with the spreadsheet extended full screen.

How to Show or Hide the Ribbon in Excel - Ribbon disapeared

And there’s one option left to explore.

How to Show Ribbon Tabs Only

So, let’s click on the Ribbon Display Options icon again, but now select ‘Show Tabs’.

How to Show or Hide the Ribbon in Excel - Show Tabs

In this view, you’ll see individual tab names.

How to Show or Hide the Ribbon in Excel - Show Tab Names

Whenever needed, just click on a tab name and you’ll see the options of the tab that were previously hidden.

How to Show or Hide the Ribbon in Excel - Pick the Function

Pick the function you need and click anywhere in the spreadsheet area to hide the options again. Only tab names will stay visible.

How to Show or Hide the Ribbon in Excel - Show Tab Names

How to Switch between All Views

To switch views according to what you need is easy – simply click on the icon in the top right-hand corner and choose whichever view suits you best. To get back to the standard view, go for ‘Show Tabs and Commands’, where all the tab names and the options are visible at all times.

How to Show or Hide the Ribbon in Excel - Show Tabs and Commands
How to Show or Hide the Ribbon in Excel - The Ribbon in Excel

And if you want to extend the working area of the spreadsheet even more, there’s another little trick that will help you.

If you’re interested in learning how to show or hide the formula bar in Excel, watch the next EasyClick Academy tutorial! You can find the link in the list below.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.