Method 1 – Use the Ribbon Display Option
Steps:
- Go to the top-right corner of the sheet.
- Click on Ribbon Display Options.
We see three options here.
- Choose either Show Tabs or Show Tabs and Commands options.
- The Show Tabs option only shows the tabs.
- The Show Tabs and Commands offer both the tabs and the commands.
Read More: How to Show Toolbar in Excel
Method 2 – Use a Keyboard Shortcut to Restore Excel Toolbar
Steps:
- Apply the keyboard shortcut Ctrl + F1 to view the whole ribbon.
- Look at the worksheet.
The toolbar is restored, and all the commands are shown here.
Read More: Types of Toolbars in Excel
Method 3 – Close the Excel File and Open it Again
Sometimes, the toolbar in Excel is unavailable for no reason. Just close and reopen the Excel file, and the toolbar will adjust automatically.
Download the Practice Workbook
Download this workbook to practice.
Related Articles
<< Go Back to Toolbar in Excel | Excel Parts | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
Hi Alok – Method 1 – Use the Ribbon Display Option is not an option for me as that icon does not appear on my screen and I could not find it in the search menu. I still cant find a way to add file menu to the excel ribbon.
Hi Heather,
If the Ribbon Display Options icon is not visible on your screen, you can try these alternatives:
Use the Keyboard Shortcut: Press Ctrl + F1 to toggle the ribbon visibility.
Customize the Ribbon Manually:
1. Go to File > Options > Customize Ribbon.
2. Check if the “File” menu is missing. If so, click Reset or add it manually.
Check for Full-Screen Mode: Press Esc or Ctrl + Shift + F1 to exit full-screen mode.
Try Safe Mode: Open Excel in Safe Mode by holding Ctrl while launching Excel to see if an add-in is causing the issue.
Regards
ExcelDemy
None of these solutions worked!
Hello Mike,
I’m sorry to hear the steps didn’t work for you. Could you share which version of Excel you’re using and describe what happens when you try to restore the toolbar? That way I can suggest a more specific fix.
Regards
ExcelDemy
MS365 – also the options tab is not there.
Hello Mike,
If toolbar is missing, click on three dot in the upper right-side of the sheet.
Then click on the down arrow and select any option of your choice.
Regards,
ExcelDemy