How to show, hide and restore missing ribbon in Excel

In this short tutorial, you will find 5 quick and easy ways to restore Excel ribbon in case it is missing and learn how to hide the ribbon to get more room for your worksheet.

Ribbon is the central point of whatever you do in Excel and the area where most of features and commands available to you reside. Do you feel the ribbon takes up too much of your screen space? No problem, one click of your mouse, and it is hidden. Want it back? Just another click!

How to show ribbon in Excel

If the ribbon has disappeared from your Excel UI, don't panic! You can quickly get it back by using one of the following techniques.

Show collapsed ribbon in full view

If the Excel ribbon is minimized so that only tab names are visible, do one of the following to get it back to a normal full display:

  • Press the ribbon shortcut Ctrl + F1.
  • Double-click on any ribbon tab to make the entire ribbon visible again.
  • Right-click any ribbon tab and clear the check mark next to Collapse the Ribbon in Excel 2019 - 2013 or Minimize the Ribbon in Excel 2010 and 2007.
    Show ribbon in Excel.
  • Pin the ribbon. For this, click on any tab to temporarily view the ribbon. A small pin icon will appear at the lower right corner in Excel 2016 and 2019 (the arrow in Excel 2013), and you click on it to always show the ribbon.
    Pin the ribbon to always show it.

Unhide ribbon in Excel

If the ribbon is hidden completely including the tab names, here's how you can restore it:

  • To unhide the ribbon temporarily, click at the very top of your workbook.
    Unhide the ribbon temporarily.
  • To get the ribbon back permanently, click the Ribbon Display Options button in the top-right corner and choose the Show Tabs and Commands option. This will show the ribbon in the default full view with all the tabs and commands.
    Show ribbon in the default full view.

Similar methods can be used to hide ribbon in Excel, and the next section explains the details.

How to hide ribbon in Excel

If the ribbon takes up too much space at the top of your worksheet, especially on a small screen laptop, you can collapse it to show only the tab names or hide the ribbon altogether.

Minimize the ribbon

To see only the tab names without commands like in the screenshot below, use any of the following techniques:
Excel ribbon hidden

  • Ribbon shortcut. The fastest way to hide Excel ribbon is to press Ctrl + F1.
  • Double-click a tab. The ribbon can also be collapsed by double-clicking an active tab.
  • Arrow button. Another quick way to hide the ribbon in Excel is to click the up arrow in the lower-right corner of the ribbon.
    Hide ribbon in Excel
  • Pop-up menu. In Excel 2013, 2016, and 2019, right-click anywhere on the ribbon and select Collapse the Ribbon from the context menu. In Excel 2010 and 2007, this option is called Minimize the Ribbon.
    Collapse the ribbon in Excel.
  • Ribbon Display Options. Click the Ribbon Display Options icon at the top-right corner and choose Show Tabs.
    Use Ribbon Display Options to only show tab names without commands.

Hide ribbon completely

If you aim to have the largest amount of screen space for a workbook area, use the Auto-hide option to get Excel in kind of full screen mode:

  1. Click the Ribbon Display Options icon on the top-right corner of the Excel window, to the left of the Minimize icon.
  2. Click Auto-hide Ribbon.

This will totally hide the ribbon, including all tabs and commands.
Hide ribbon completely including all tabs and commands.

Excel ribbon missing – how to restore it

If all of a sudden the ribbon disappears from your Excel, it's most likely to be one of the following cases.

Tabs show up but commands disappeared

Perhaps you have inadvertently hidden the ribbon with an errant keystroke or mouse click. To show all the commands again, click Ctrl + F1 or double-click any ribbon tab.

Whole ribbon missing

Most probably your Excel somehow got into a "full screen" mode. To restore the ribbon, click the Ribbon Display Options button Ribbon Display Options button  at the top-right corner, and then click Show Tabs and Commands. This will lock the ribbon at the top of the Excel window where it belongs. For the detailed instructions, please see How to unhide ribbon in Excel.

Contextual tabs disappeared

If the Tool Tabs specific to a particular object (such as a chart, image, or PivotTable) are missing, that object has lost focus. For the contextual tabs to appear again, simply select the object.

Add-in's tab missing

You've been using some Excel add-in (e.g. our Ultimate Suite) for a while, and now the add-in's ribbon is gone. Chances are the add-in was disabled by Excel.

To fix this, click File > Excel Options > Add-ins > Disabled Items > Go. If the add-in is in the list, select it and click the Enable button.

That's how you hide and show ribbon in Excel. I thank you for reading and hope to see you on our blog next week!

You may also be interested in:

5 Responses to "How to show, hide and restore missing ribbon in Excel"

  1. Imran Masud says:

    Thanks svetlana.

  2. Faisal says:

    Dear Svetlana
    Could you please guide me about how to sum numbers greater than zero by the months. (i.e. if there are number of months and we have values in them but count the numbers which have value greater than zero in that month).
    Regards
    Faisal
    Faisal.aziz26 @ gmail

    • Dear Faisal,

      You can use the SUMIFS or COUNTIFS function for this, depending on whether you want to add up all non-zero values for a specific month or just count the number of non-zero values for a given month.

      An exact formula will depend on how months are input in your data set (dates, numbers representing the months, or month names as text). If you can provide a small sample of your data and an expected result, I will try to help with the formula.

  3. Debra says:

    Could you please help. In Excel 2016 the ribbon and menu bar are missing, but the Ribbon Display Options icon is not available to restore them, only the minimize, maximize and close icon are displayed in the top right corner. Tried CTRL + F1 but not this has not worked. Thanks in advance for any help.

  4. Bharath says:

    The add-in tab is appearing even after I uninstall the respective adding app.
    I checked, no open key available in hkcu. The add-in is coming from excel15.xlb. I can't remove the .club file as it stores other user customisation data related to excel ribbon.
    Kindly suggest.

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard