Excel Shortcut Keys Free Articles Focusing
Excel Shortcut Keys How To Show Or

We share our experience and knowledge through blog articles, demos, eBooks, videos and glossary terms for the benefit of webmasters and tech community.

The ribbon area occupies the top portion of excel containing tool icons and text descriptions for each menu tabs.

When you have a larger excel sheets, you should get rid of the ribbon area to get convenient space.

It also makes sense to show or hide that ribbon when you needed.

Excel Shortcut Keys How To Show Or

In this article let us discuss how to show or hide ribbon in Excel on Windows and MacBook.

This will hide the ribbon showing all the menu items, thus allowing to have some visible area for cells.

This will do the same function as the arrow button and hide the ribbon.

Once hide the ribbon, the arrow will also disappear as it is also part of the ribbon.

Now that you need breaking your head to enable the ribbon again as you need those menu options.

The same problem exists with right clicking and collapsing the ribbon.

This means you can hide and show the ribbon by pressing these shortcut keys.

We recommend to use this shortcut keys instead of using the arrow or right click to hide ribbon.

This should also work on Word, PowerPoint and all Microsoft applications.

If you want to enable the ribbon again, click on the three dots in the top bar which will show the ribbon temporarily.

Now you will see a small pin icon at the lower right corner of the ribbon.

This will ensure the ribbon is always there when you work on that spreadsheet.

You will see Excel Option popup showing options for Customize Ribbon section.

If something goes wrong click Reset all customizations from the Customizations dropdown to set the ribbon back to initial settings.

This means ribbon will show when you press the shortcut keys first time and then will be hidden if you press second time.

This arrow will show up when the ribbon is visible and show down when the ribbon is hidden.

Also remember Command Option R shortcut keys will work on Mac Excel, only if you have turned on Ribbon in preferences.

After opening the workbook, you can toggle the ribbon appearance either using the arrow or with shortcut keys.

You can change the order and rearrange the icon tools for your convenience.

Excel Shortcut Keys Free Articles Focusing

We have published 2000 free articles focusing on website building and technology.

Excel For Mac Shortcut Keys