How to Show Menu Bar in Excel (2 Common Cases)

This tutorial will demonstrate how to show menu bar in excel. The menu bar gives you easy access to many necessary commands of excel. The main functions of the menu tab are File, Home, Insert, Page Layout, Formulas, Data, Review, etc. In our case, we want to show the menu bar in the excel worksheet display.


Download Practice Workbook

You can download the practice workbook from here.


2 Common Cases to Show Menu Bar in Excel

We want to show menu bar in excel with the consideration of two specific cases. In our first case, we will show the menu bar in case it’s hidden completely before and in the second case, we will restore the menu bar for different conditions. We will discuss every case below:


Case-1: Showing Menu Bar in Excel

Our main goal is to show menu bar in excel considering two cases. One is directly showing the menu in case of collapsed ribbon and the other is to unhide the menu bar by using the rib

 

bon display option.


Displaying Collapsed Ribbon

In case the Excel Ribbon is collapsed, then we can display it on our window screen by doing any of the following options.

  • One option is to press Ctrl + F1 on both buttons at the same time to display the menu bar.
  • Another option is to Double-click on any option of the ribbon tab.

Showing Menu Bar in Excel

  • The third option can be select any of the ribbon tab options and Right-click on it.
  • Then choose the Collapse the Ribbon option to display the ribbon tab.

Showing Menu Bar in Excel


Unhide Menu Bar Using Ribbon Display Option

In our second case, our goal is to unhide the menu bar with the help of the Ribbon Display Option. The description of this process is given below.

Steps:

  • We will use this process if the ribbon tab has completely disappeared like the below image.

Showing Menu Bar in Excel

  • In this case, click on the top right side of your window worksheet and select the three-dot(…) option.

Showing Menu Bar in Excel

  • After that, you will find the hidden menu bar like the below image.

  • But if you want to display the menu permanently, then go to the Ribbon Display Options button and choose Show Tabs and Commands.

Read More: How to Move Up and Down in Excel (5 Easy Methods)


Similar Readings


Case-2: Restoring Missing Menu Bar in Excel

When you are dealing with lots of data or keyphrases, there can be a sudden accident like missing some or a whole portion of the ribbon tab. So, in this case, our goal is to restore the missing menu bar in excel for the following cases:

Tabs of Menu Bar Displayed but Commands Missing

If this scenario happens, then just press Ctrl + F1 or Double-click on any ribbon tab to get the whole ribbon with commands.


Full Menu Bar Disappeared

When you have gone into the full-screen mode then you have to restore it by following the steps similar to case 1.

Short description: click Ribbon Display Options> Show Tabs and Commands.


Tool Tabs Missing

Our goal is to show a new tool tab in the menu bar. For that, we will gonna follow the steps.

Steps:

Restoring Missing Menu Bar in Excel

  • Then choose Options.

Restoring Missing Menu Bar in Excel

  • After that Excel Options window will open on your screen.
  • At this point, go to Customize Ribbon option.
  • Next, select the desired tabs from the Main Tabs option and press OK.

Restoring Missing Menu Bar in Excel

  • Finally, you get your desired tab tool on the menu bar.


Add-in’s Tab Disabled

Our main goal is to enable the Add-in tab to show in the menu bar. For this we will do as described below:

Steps:

  • At first, like in the previous case, go to File>More Options to open the Excel Options window.

  • Then go to the Add-ins option and select Excel Add-ins to enable the option and press OK to enable this option.

Restoring Missing Menu Bar in Excel

Read More: How to Move Data from Row to Column in Excel (4 Easy Ways)


Hiding Menu Bar in Excel Using Auto-hide Ribbon Option

Our goal is to hide the menu bar in excel. Sometimes it can be needed to hide the menu bar to represent the worksheet well to the viewer. In this case, we will use the Auto-hide Ribbon option to hide the menu bar as described below:

Steps:

  • First, go to the right side of the worksheet.
  • Then click on the Ribbon Display Options.
  • Lastly, select the Auto-hide Ribbon option to hide the whole ribbon like the initial steps of the previously described methods above.

  • The final result should be similar to like the below image.


Things to Remember

  • The fastest way is to use Ctrl + F1 keyboard shortcut to show the menu bar.
  • These steps will be only needed if the menu bar is missing or some portion of it is missing. Otherwise, using this method can make the menu bar disappear in some cases.
  • When adding new Tool Tabs to the menu bar, it should be remembered that the tab will be on the menu bar the whole time. If after the specific work, you don’t need the added tool then you can unselect it to remove it from the menu bar again.

Conclusion

Henceforth, follow the above-described methods. Thus, you can learn how to show menu bar in excel. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo