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.
How to Restore Ribbon in Excel: 5 Quick Ways
1. Using Ribbon Display Options to Restore Ribbon
If you don’t see the ribbon, maybe you’ve entered into 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 your main ribbon straightway.
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.
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.
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.
- First, press ALT + F11 to open the VBA Editor.
- Then go to Insert ➤ Module.
- Now insert and save the following VBA code in the VBA Editor.
- 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 Use Excel VBA to Customize Ribbon
5. Restarting Excel to Restore Ribbon
If you did everything to restore the ribbon yet it’s not restoring, then you can follow these two steps:
- Close your Excel application.
- Then re-open the Excel application.
This will bring back the lost ribbons.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
To sum up, we have discussed 5 ways to restore the ribbon in Excel. You are recommended to download the practice workbook attached to 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.
- How to Display Developer Tab on the Ribbon in Excel
- How to Add Data Types to Ribbon in Excel
- How to Add Custom Ribbon Using XML in Excel