How to Restore Ribbon in Excel (5 Quick Ways)

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.

Using Ribbon Display Options to Restore Ribbon

This will restore back your main ribbon straightway.

Output of Using Ribbon Display Options to Restore Ribbon

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.

Enabling Add-ins to Restore Ribbon in Excel

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.

Unchecking Collapse the ribbon to Restore Contextual Tabs in Excel

So, after following the steps above, you will see the contextual tabs are restored like this.

Read More: Understanding contextual tabs in Excel Ribbon


Similar Readings


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.

Insert a new module to Use VBA Code to Restore Ribbon

❸ Now insert the save the following VBA code in the VBA Editor.

Sub Restore_Ribbon()

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"

End Sub

Use VBA Code to Restore Ribbon

❹ 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)


Conclusion

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.


Related Articles

Tags:

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo