Excel Sheet Tabs Disappeared

On the excel options dialog box click advanced in the list of items on the left.

Excel sheet tabs disappeared. Click advanced on the excel options window. Click options at the bottom of the left column. Assure that the show sheet tab check box is selected. Try maximizing the window to reveal the tabs.

Scroll down to the display options for this workbook section not the display section and select the show sheet tabs check box so there is no check mark in the box. Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook. This might be the case that excel sheet tabs go missing as the sheet tabs setting is turned off. In contrast you may want to hide some sheet tabs or the entire sheet tab bar for some reasons.

Click the ok button. By default microsoft excel shows sheet tabs at the bottom of the worksheet which is functioning for navigating between worksheets quickly. These steps are. Here is how to show your excel 2013 tabs if they are all hidden open excel 2013.

So verify it follow the steps to do so. The show sheet tabs setting is turned off. Sometimes the sheet tabs may disappear by accident in excel. Click file options advanced then under display options for this workbook.

Simply double click the window title bar. Click the file tab. If this occurs as shown in the figure you can double click on the workbook s name to maximize the window and restore your workbook tabs. If you still don t see the tabs click view arrange all tiled ok.