How to Restore Toolbar in Excel (3 Quick Methods)

The Toolbar missing is one of the common issues in Excel. When Toolbar disappears, it becomes very difficult for the users to perform different tasks. Now, we will show how to restore the Toolbar in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Quick Ways to Restore Toolbar in Excel

Now, we will show 3 different methods to restore Toolbar. Have a look at how an Excel sheet looks without Toolbar.

Only Commands Are Missing:

Both Tabs & Commands Are Missing:


1. Use Ribbon Display Option

The toolbar may disappear if the Ribbon is hidden. We can unhide the Ribbon from the Ribbon Display Options icon. Follow the steps below.

Steps:

  • Go to the top-right corner of the sheet.
  • Click on Ribbon Display Options.

Ribbon Display Option to restore toolbar

We see three options here. We can choose either Show Tabs or Show Tabs and Commands options.

The Show Tabs option shows the tabs only.

The Show Tabs and Commands offer both the tabs and the commands.


2. Use Keyboard Shortcut to Restore Excel Toolbar

In this section, we will use a keyboard shortcut that will view the whole ribbon and restore the toolbar.

Steps:

  • Here, we see only the tabs of the Excel sheet. But commands are not showing. We will apply the keyboard shortcut Ctrl+F1 that will view the whole ribbon.

  • Now, look at the worksheet.

Keyboard Shortcut to Restore Excel Toolbar

The toolbar is restored and all the commands are shown here.


3. Close Excel File and Open Again

Sometimes we face unavailability of the toolbar in Excel without any reason. Just close the Excel file and reopen the Excel file. The toolbar will adjust automatically.


Conclusion

In this brief article, we described 3 quick ways to restore the toolbar in Excel. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo