Next, we will click on any of the menu items to see the ribbon again.

To keep our Ribbon fixed at the top of the workbook, we will first, press Ctrl + F1 to hide the ribbon.

These shortcut keys also work for PowerPoint, Word and all Microsoft Applications.Īlternatively, we can use the shortcut Command +Option+ R to show or hide the ribbon on Excel Mac. We will simply press Ctrl + F1 anytime to turn on or off the ribbon. We can use handy shortcut keys to hide or show ribbon. If we wish to show the Ribbon, we will simply right-click on the ribbon and choose the “ Collapse the Ribbon ” option.įigure 7 – Excel Show Ribbon How to Hide Ribbon using the Shortcut Keys We can also right-click anywhere on the ribbon to show or hide the Ribbon menu. This arrow will show at the top when the ribbon is visible and at the button when the ribbon is hidden. We can also find this arrow at the top of our Excel Ribbon in Mac. When we hover around it, it will assume the color of the ribbon (green color) until we click on it to show the ribbon.

Now, we can click to show Ribbon, by selecting the three dots at the top right above the formula bar.

If we select the Autohide Ribbon option, then the entire ribbon (Tabs and commands) will be hidden.

When we click on this arrow, we will find three options the Auto Hide Ribbon, Show Tabs and Show Tabs and Commands

At the top of our ribbon, we will now find an arrow.

We can click on this arrow to hide the ribbon menu.

The quickest way to hide the ribbon is by using the small up arrow at the bottom right of our ribbon.

In this tutorial, we will illustrate four easy ways to show or hide the ribbon on Windows and MacBook.įigure 1 – Excel Hide ribbon Excel Hide or Show Ribbon in Windows using the Arrow Buttons

If we wish to have more space for our excel sheet, it is possible to hide the ribbon. The Ribbon Menu is the top portion of our Excel workbook and it takes a lot of space. We can hide or view ribbon in Excel in many easy ways.

How to hide or show the Excel Ribbon menu in Windows and Mac – Excelchat

Tools menu in excel 2016 mac