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.
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.
Read More: How to Show Toolbar in Excel (4 Simple Ways)
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.
The toolbar is restored and all the commands are shown here.
Read More: Types of Toolbars in MS Excel (All Details Explained)
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.