To see them, simply move your mouse to the top of the workbook and click.If you select the option of Auto-hide Ribbon, while working on the sheet, the ribbon and toolbar disappear.Right-click the tab and uncheck Collapse the Ribbon (or Minimize the Ribbon, depending on your Excel version).Then, to the lower right of the screen, click the pin icon to pin the ribbon to the screen permanently.

Click on a tab to view the ribbon temporarily.

If the toolbar is not showing in Excel, the ribbon shortcut makes it visible. Pressing the ribbon button when the toolbar is visible hides it.

Press CTRL + F1, which is the ribbon shortcut.

Other solutions for when Excel toolbars are missing

Select the add-ins for which its tab is missing and hit Enable.ģ.

If Excel disables the add-in, you will find it on the list here.

Next, navigate to the Add-ins section from the left panel and select Disabled Items.

Hit the File menu link at the top of the page.

If the add-in’s tab is not showing in Excel

Select either Show Tabs or Show Tabs and Commands to display your toolbar to show the missing Excel toolbar.Ģ.

Display the tabs and commands at all times.

Display only the tabs and leave the toolbar and ribbon hidden.

The ribbon disappears when you work on the sheet and shows up only when you hit ALT or click on the More ellipse icon.

In an MS Excel window, click on the Ribbon Display Options icon to reveal the following options:.

How do I get my toolbar back in Excel? 1. Learn how to get your toolbar back in Excel. Incorrect display settings commonly cause it. The missing or hidden toolbar in Excel is a common complaint, but this is not usually a bug or issue from Excel itself. Without these crucial elements in Excel, you won’t be able to get jobs done quickly, so, understandably, you are searching for fixes. The toolbar missing makes it tough to get work done with the Excel. Microsoft Excel is one of the most sophisticated tools in the Office suite, and it comes with loads of functions, most of which are manipulated using the toolbar.

Restoro has been downloaded by 0 readers this month.

Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).Ĭlick Start Scan to find Windows issues that could be causing PC problems.Ĭlick Repair All to fix issues affecting your computer's security and performance.

Home › Fix › Toolbar not showing in Excel? Here’s what you can do

Excel mac developer tab has disappeared