You may find your Excel ribbon hidden for several reasons. In this article, you will learn 5 quick methods to restore your ribbon back in Excel with ease.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
5 Ways to Restore Ribbon in Excel
1. Using Ribbon Display Options to Restore Ribbon
If you don’t see the ribbon, maybe you’ve entered into the full-screen mode.
However, you can restore the main ribbon quite quickly.
❶ Just click on the Ribbon Display Options icon at the top-right corner.
❷ Then select Show Tabs and Commands.
This will restore back your main ribbon straightway.
Read More: MS Excel Ribbon and Its Function
2. Enabling Add-ins to Restore Ribbon in Excel
If you see any add-ins missing from the main ribbon, it is just because Excel has disabled your add-ins.
To enable it again,
❶ Go to the File tab from the main ribbon.
❷ Click on Options.
❸ Go to Options from the Excel Options dialog box.
❹ Under the Manage drop-down, select Disabled Items and hit Go.
❺ After that, click OK.
After following the above steps, Excel will automatically enable all the disabled add-ins.
Read More: Types of commands on the Ribbon
3. Restoring Contextual Tabs in Excel
If you don’t see the contextual tabs under the main ribbon, you can restore them quite easily.
❶ Right-click on a tab name from the main ribbon.
❷ Then uncheck Collapse the Ribbon.
You can also press CTRL + F1 as a shortcut key to restore the contextual tabs.
So, after following the steps above, you will see the contextual tabs are restored like this.
Read More: Understanding contextual tabs in Excel Ribbon
- How to show the Developer Tab on the Ribbon
- [Solved]: Data Types Stocks and Geography Missing Problem in Excel (3 Solutions)
- How to Add Data Types to Ribbon in Excel (With Quick Steps)
4. VBA Code to Restore Ribbon
Now, we will use a VBA code to restore the ribbon in Excel.
If your Excel application looks like this and can’t even find the Ribbon Display Options, you can use this VBA code.
❶ At first, press ALT + F11 to open the VBA Editor.
❷ Then go to Insert ➤ Module.
❸ Now insert the save the following VBA code in the VBA Editor.
Sub Restore_Ribbon() Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)" End Sub
❹ After that, press the F5 key to run the above code.
This code will restore the main ribbon in Excel straightway.
Read More: How to Show, Hide, & Customize Excel Ribbon
5. Restarting Excel to Restore Ribbon
If you did everything to restore the ribbon yet it’s not restoring back, then you can follow these two steps:
❶ Close your Excel application.
❷ Then re-open the Excel application.
This will bring back the lost ribbons.
Read More: How to Show Ribbon in Excel (5 Quick & Simple Ways)
To sum up, we have discussed 5 ways to restore the ribbon in Excel. You are recommended to download the practice workbook attached with this article and practice all the methods. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.