The toolbar missing is one of the common issues in Excel. When the toolbar disappears, it becomes very difficult for the users to perform different tasks. Now, we will show how to restore the toolbar in Excel.
Restore Toolbar in Excel: 3 Ways
Now, we will show 3 different methods to restore toolbar in Excel. Have a look at how an Excel sheet looks without a 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
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 Excel
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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this brief article, we described 3 quick ways to restore the toolbar in Excel. Restoring the toolbar in Excel is crucial as it provides quick access to essential commands and functions, enhancing productivity. It simplifies complex tasks by offering a user-friendly interface with readily available tools. Additionally, a visible toolbar reduces frustration and saves time for users, making Excel more efficient and user-friendly.
Related Articles
<< Go Back to Toolbar in Excel | Excel Parts | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!