Tutorial How to Auto Hide, Hide and Show Ribbon in Excel

Ribbon Display Options is a feature embedded at the top of the Microsoft Excel 2016 window to make it easier to adjust the appearance of the Ribbon. Previously, the feature was already in Microsoft Excel 2007, but due to its hidden presence, most users encountered problems with missing or hidden Microsoft Excel ribbons. The function of the Ribbon Display Options is to allow users to hide and unhide the Ribbon in Excel. There are new features provided are Auto Hide, The program automatically displays the Ribbon in Microsoft Excel when the mouse is hovered over the Tab Menu.


A. How to Show Ribbon in Excel with Ribbon Display Options

  1. Click the Ribbon Display Options in the upper right corner of Microsoft Excel

    Making the Ribbon In Excel
    Making the Ribbon In Excel
  2. Then Select “Show Tabs and Commands”

  3. Then the Ribbon will be displayed

    Bring up the ribbon in Microsoft Excel 2016
    Bring up the ribbon in Microsoft Excel 2016

B. How to Show Ribbon in Excel with Right Mouse Click

To use this method, you can simply right click on an empty ribbon and select “Collapse the Ribbon” so the check mark on the option disappears.

collapse the ribbon in Excel
Collapse the ribbon in Excel

C. How to Hide the Ribbon in Excel with Ribbon Display Options

  1. Click the Ribbon Display Options in the upper right corner of Microsoft Excel

    Making the Ribbon In Excel
    Hiding the Ribbon in Excel
  2. Then Select “Show Tabs”

  3. Then the Ribbon will be hidden


D. How to Hide Ribbon in Excel with Right Mouse Click

To use this method you simply right click on an empty ribbon area and select “Collapse the Ribbon” like the following illustration. This can be marked by the appearance of a check mark on the Collapse the Ribbon.

collapse the ribbon in Microsoft Excel
collapse the ribbon in Microsoft Excel

E. How to Hide or Show Ribbon in Excel with Keyboard

You can show or hide the Ribbon by using the keyboard shortcut ctrl+f1


F. How to Enable Auto Hide: Auto Hide feature and show Ribbon

  1. Click the Ribbon Display Options in the upper right corner of Microsoft Excel

    Making the Ribbon In Excel
    Auto Hide Ribbon in Excel
  2. Then Select “Auto Hide Ribbons”

  3. Then the Auto Hide Feature is Active in full Window mode.

  4. The Ribbon will appear when you click on the top of the Excel window.

    auto hide microsoft excel
    auto hide microsoft excel

source: https://www.advernesia.com

Someone who has an aloof personality, without knowing the outside world only through the online world.

  • Facebook
  • WhatsApp
  • Instagram