Excel guide · 4 min read
Excel sheet tabs missing: how to show them again
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | What you see | Cause | Fix |
| 2 | No tab bar at all, scroll bar still there | Show sheet tabs is off for this workbook | File > Options > Advanced > Show sheet tabs |
| 3 | One or two tabs, long scroll bar | Scroll bar dragged over the tabs | Drag the three-dot splitter to the right |
| 4 | No tabs, no scroll bar, no status bar | Window bottom is off-screen | Maximize, or View > Arrange All |
| 5 | Tab bar there, one sheet missing | Sheet is hidden | Right-click a tab > Unhide |
| 6 | Unhide is greyed out | Workbook structure is protected | Review > Protect Workbook (enter password) |
| 7 | Too many tabs to find one | Tab bar too narrow | Right-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.
- Go to File > Options > Advanced.
- Scroll to Display options for this workbook and make sure the workbook name in the box is the right one.
- Tick Show sheet tabs and click OK.
- 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.
- Find the three dots just left of the horizontal scroll bar.
- Point at them until the cursor becomes a double arrow.
- 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
- How to unhide sheets in Excel
- Excel ribbon missing: how to get it back
- Excel formula bar missing or not showing: how to get it back
- How to remove the dotted page break lines in Excel
- How to turn on dark mode in Excel
Updated