Where are my worksheet tabs? (2024)

The window sizingis keeping the tabs hidden.

• If you restore multiple windows in Excel, ensure that the windows are not overlapping. Perhaps the top of an Excel window is covering the worksheet tabs of another window.

  

• The status bar has been moved all the way up to the Formula Bar.

  

• Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook.

Try maximizing the window to reveal the tabs. Simply double-click the window title bar.

If you still don't see the tabs, click View > Arrange All > Tiled > OK.

The Show sheet tabs setting is turned off.

First ensure that the Show sheet tabs is enabled. To do this,

• For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.

  

The horizontal scroll bar obscures the tabs.

Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs.

The worksheet itself is hidden.

To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK.