Cellwise Start free

Excel guide · 4 min read

Excel sheet tabs missing: how to show them again

Quick answerGo to File > Options > Advanced, scroll to Display options for this workbook, tick Show sheet tabs and click OK. If that's already ticked, the horizontal scroll bar has probably been dragged over the tabs: drag the small three-dot handle at its left edge to the right. If only one sheet is missing, it's hidden: right-click any tab and choose Unhide.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABC
1What you seeCauseFix
2No tab bar at all, scroll bar still thereShow sheet tabs is off for this workbookFile > Options > Advanced > Show sheet tabs
3One or two tabs, long scroll barScroll bar dragged over the tabsDrag the three-dot splitter to the right
4No tabs, no scroll bar, no status barWindow bottom is off-screenMaximize, or View > Arrange All
5Tab bar there, one sheet missingSheet is hiddenRight-click a tab > Unhide
6Unhide is greyed outWorkbook structure is protectedReview > Protect Workbook (enter password)
7Too many tabs to find oneTab bar too narrowRight-click the arrows left of the tabs

1. Turn Show sheet tabs back on

This setting belongs to the workbook, not to Excel, so a file someone else sent you can open with no tabs while your own files look fine. It gets switched off by accident, or on purpose by people building a dashboard who don't want readers clicking around.

  1. Go to File > Options > Advanced.
  2. Scroll to Display options for this workbook and make sure the workbook name in the box is the right one.
  3. Tick Show sheet tabs and click OK.
  4. Save the file so it opens with tabs next time.

2. The scroll bar is covering the tabs

The tab bar and the horizontal scroll bar share one strip at the bottom of the window, with a small splitter (three vertical dots) between them. Drag it left and the scroll bar grows over the tabs until only one is visible, or none. It's easy to do while scrolling and looks exactly like missing tabs.

  1. Find the three dots just left of the horizontal scroll bar.
  2. Point at them until the cursor becomes a double arrow.
  3. Drag right until the tabs show again.

3. The bottom of the window is off-screen

If the tabs, the scroll bar and the status bar have all gone, the window is probably taller than the screen or pushed down past it, which happens after unplugging a second monitor. Maximize the window (double-click its title bar, or Windows key + Up arrow). If several workbooks are open, View > Arrange All > Tiled fits them all on screen.

If the ribbon and formula bar are gone too, Excel is in full screen mode: press Ctrl+Shift+F1. Excel ribbon missing covers that and the other display modes.

4. Tabs are there, but a sheet is missing

That's a hidden sheet, not a hidden tab bar. Right-click any tab and choose Unhide; Excel for Microsoft 365 lets you pick several at once. If Unhide is greyed out, either nothing is hidden or the workbook structure is protected: Review > Protect Workbook toggles it off, with the password if one was set.

A sheet set to "very hidden" with VBA won't appear in the Unhide list at all. How to unhide sheets in Excel walks through all of these cases.

5. Too many tabs to find the one you want

With dozens of sheets, most tabs sit off the end of the bar. Right-click the small arrows at the left of the tab bar to get a list of every visible sheet and jump straight to one. Ctrl+Page Down and Ctrl+Page Up move to the next and previous sheet from the keyboard, which works even when the tabs are hidden.

On Excel for Mac, the workbook setting is under Excel > Preferences > View. In Excel for the web, the tabs always show at the bottom; if you can't see them, zoom out in the browser or close the side panes.

Keyboard shortcut: Next sheet: Ctrl+Page Down

Common mistakes

Looking for the setting in the View tab

Show sheet tabs is in File > Options > Advanced, under Display options for this workbook.

Changing the option for the wrong workbook

The section has a workbook drop-down. Choose the file you're looking at before ticking.

Assuming tabs are hidden when one sheet is

If the bar shows other tabs, the sheet itself is hidden. Right-click a tab > Unhide.

FAQ

Why did my sheet tabs disappear in Excel?

Usually Show sheet tabs was turned off for that workbook, the scroll bar was dragged over the tabs, or the window extends past the bottom of the screen. Check those three in that order.

How do I show sheet tabs in Excel?

File > Options > Advanced > Display options for this workbook > tick Show sheet tabs. Then save so it sticks.

How do I switch sheets without tabs?

Press Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous one. They work whether the tabs are visible or not.

Why are only some of my sheet tabs showing?

Either the scroll bar is taking up most of the strip, or some sheets are hidden. Drag the splitter right, then right-click a tab and choose Unhide to check for hidden sheets.

What if the row numbers and column letters are missing too?

Those are a per-sheet setting rather than a workbook one: tick View > Headings on each affected sheet. Excel row numbers and column letters missing has a one-line way to fix every sheet at once.

Related guides

Updated