Excel Sheet Tabs Missing: Where Did They Go?

You open a workbook that used to have seven tabs along the bottom. The data is intact, the size is unchanged, and the strip now shows one sheet — or nothing at all. In most of these files the other worksheets have not been deleted. They are hidden, very hidden, locked behind workbook protection, or the tab strip itself has been switched off. Which of the four it is decides the fix, so the checks below run from least invasive to most.

Why tabs vanish while the data stays

Sheet visibility in a modern .xlsx is a property, not a separate file. Every worksheet keeps its own part in xl/worksheets/ no matter what state it is in, and xl/workbook.xml records how each one should appear: <sheet name="Q3" sheetId="4" state="hidden" r:id="rId5"/>. Remove the state attribute and the tab is visible again. Nothing was thrown away, which is why the file size does not change.

There are two hidden states, and the difference matters. hidden is what you get from the right-click menu. veryHidden can only be set through VBA, and Excel deliberately leaves it out of the Unhide dialog, so a workbook can look empty while holding five full sheets.

A third path is not hiding at all: Excel remembers the tab strip setting per workbook, so a file can arrive with Show sheet tabs unticked. The sheets are visible in every sense except that there is no strip to click.

The last cause is protection: with workbook structure protected, Excel greys out Hide and Unhide instead of refusing, so the tabs look lost and the menu looks broken at once.

Fix 1 — Turn the tab strip back on

Go to File → Options → Advanced, scroll to Display options for this workbook, and tick Show sheet tabs. Click OK. This is stored in the workbook, so it travels with the file: a colleague who hides the strip for a cleaner dashboard hides it for you too.

If the box is already ticked, the strip is being pushed out of view rather than disabled. Maximise the Excel window, drag the horizontal scrollbar back to the left, and check View → Full Screen, which hides the ribbon and can push the strip off a small laptop screen.

Fix 2 — Unhide from the ribbon

With any tab visible, use Home → Cells → Format → Hide & Unhide → Unhide Sheet, or right-click a tab and choose Unhide. Excel lists every hidden sheet one per pass, so repeat until the list is empty.

If the command is greyed out, either nothing is hidden or the workbook is protected. If the strip is entirely blank, Excel is not simply hiding everything: it refuses to hide the last visible sheet, so you are looking at very hidden sheets or protection.

Fix 3 — Very hidden sheets never appear in that dialog

Press Alt+F11, then Ctrl+G to open the Immediate window, and type:

For Each ws In ThisWorkbook.Worksheets
    ws.Visible = xlSheetVisible
Next ws

Press Enter on the last line. Every sheet becomes visible, including the ones the Unhide dialog refused to list. Save afterwards, or the state reverts when you close.

If the VBA editor refuses to open, the project is password protected. Do not spend long on it — Fix 5 gets the same sheets without code.

Fix 4 — Unprotect the workbook structure

Go to Review → Protect Workbook. If the button reads Unprotect Workbook, the structure is locked and that is why Hide and Unhide are dimmed. Click it and supply the password.

Workbook structure protection is not encryption: it stops the interface from changing the sheet list, not anyone from reading the cells, and it does not survive a determined edit of the file. When the password is lost, work on a copy, rename it from .xlsx to .zip, open xl/workbook.xml in a plain text editor, and delete the single <workbookProtection .../> element. Save, rename back to .xlsx, and open it. Keep the untouched copy until the result is verified.

Fix 5 — Prove the sheets still exist in the package

This step separates a display problem from a damaged file. Copy the workbook, rename the copy to .zip, and open it. Count the parts in xl/worksheets/: a seven-sheet workbook has seven XML files there even if only one tab shows.

Then read the <sheets> block in xl/workbook.xml. Names, sheet IDs, and r:id values must line up with xl/_rels/workbook.xml.rels. If the sheet parts exist but the <sheets> list has lost entries, Excel has nothing to draw a tab from — that is real corruption, and it is where File → Open → Browse → arrow beside Open → Open and Repair is worth running on a copy. The limits of that route are described in what “we found a problem with some content” actually means.

Fix 6 — Take a previous version instead of repairing

If the tabs disappeared after a crash or an unintended save, stop editing. In OneDrive or SharePoint, use File → Info → Version History and open the version from before the change; the full sheet list comes back with it. The same reasoning applies to a workbook that was overwritten, which I covered in restoring an Excel file that was saved over.

For a file that was never saved after the sheets vanished, check File → Info → Manage Workbook → Recover Unsaved Workbooks, and look for .xlk backup files beside the original.

When it is not worth fixing

Stop when xl/worksheets/ is empty, or when the sheet parts are there but a few hundred bytes each. An empty worksheet part is a worksheet with no cells, and no unhide command refills it.

Stop as well when only one part survived and it is a summary tab. Rebuilding the formatting of five sheets is hours of work, and paying for the layout of an empty workbook helps nobody.

The one destructive move to avoid: opening the file, seeing no tabs, and pressing Save. That writes the current view to disk and removes the window in which version history could still have helped.

If the parts are intact but the sheet list is broken, the workbook is recoverable and the extract-and-rebuild work is what the repair service handles.

FAQ

The tabs are gone but the file size never changed. Does that mean nothing was lost? Usually yes. Hiding does not remove data, so an unchanged size points at visibility or protection rather than deletion. Confirm it in xl/worksheets/ first.

Can a workbook really have zero visible sheets? Not through the normal interface; Excel blocks hiding the last one. It happens through VBA or through a workbook whose sheet entries were damaged, which is why a blank strip should send you to Fix 3 and Fix 4 first.