How to Restore Ribbon in Excel (5 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Using Ribbon Display Options to Restore Ribbon

  • This will restore your main ribbon straightway.

Output of Using Ribbon Display Options to Restore Ribbon


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.


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.


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.

Insert a new module to Use VBA Code to Restore Ribbon

  • Now insert and 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 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.


Conclusion

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.


Related Articles


<< Go Back to Customize Excel Ribbon | Excel Ribbon | Excel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo