How to Restore the Toolbar in Excel (3 Quick Methods)


Method 1 – Use the Ribbon Display Option


  • 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.

  • 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


  • Apply the keyboard shortcut Ctrl + F1 to view the whole ribbon.

  • Look at the worksheet.

Keyboard Shortcut to Restore Excel Toolbar

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 ExcelExcel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF