Excel Workbook Not Showing Sheet Tabs? Fixes That Work

How-to basics · Updated November 18, 2026

If an Excel workbook is not showing sheet tabs, first check File > Options > Advanced and, under Display options for this workbook, select Show sheet tabs. If that option is already on, the tabs may be hidden behind the horizontal scrollbar, or the workbook may have individual sheets set to hidden.

Check whether the tabs are merely out of view

In Excel for Microsoft 365 on Windows, worksheet tabs normally appear along the bottom-left edge of the workbook window, just above the status bar. Before changing settings, look along the full bottom edge of the workbook. If you can see a few tabs but not the one you need, use the small navigation arrows at the far left of the tab area to scroll through the tabs. Those arrows move the tab display; they do not change which sheets are in the workbook.

The horizontal scrollbar can also take up so much space that tabs seem to have disappeared. Look for the small vertical divider between the sheet tabs and the scrollbar. Drag it to the right to make more room for the tabs, or left to make more room for scrolling across worksheet columns. If the workbook is in a separate window, maximize that window using its title bar controls; a narrow window can leave very little room for tab names.

  • Tabs visible, but one is missing: scroll the tab strip or check whether that particular sheet is hidden.
  • No tabs visible at all: check the workbook’s Show sheet tabs setting.
  • Only part of a tab name appears: widen the tab area or the workbook window.

Turn on Show sheet tabs in Excel for Windows

The sheet-tab display option is stored for the workbook, so it can be off in one file while tabs appear normally in another. To check it in Excel for Microsoft 365 on Windows:

  1. Open the affected workbook and select File > Options.
  2. Choose Advanced in the left-hand list.
  3. Scroll to Display options for this workbook. If more than one workbook is open, make sure the correct workbook is selected in the section’s workbook list.
  4. Select Show sheet tabs, then click OK.

If the box was cleared, selecting it should make the tab strip reappear immediately. If it was already selected, the problem is likely something else; continue with the checks below rather than repeatedly changing the same setting. The similarly named options for showing horizontal and vertical scroll bars control those bars, not whether worksheet tabs are displayed.

This is a workbook display setting, not a command to unhide every worksheet. It is possible for the tab strip to be visible while one or more individual sheets remain hidden. Conversely, turning off Show sheet tabs hides the entire strip even if the workbook contains several visible worksheets.

Unhide an individual worksheet

If tabs are visible but a specific worksheet is absent, that sheet may have been hidden. In Windows Excel, right-click any visible sheet tab and choose Unhide. Select the worksheet name in the dialog and click OK. You can also use the ribbon: select Home > Format > Hide & Unhide > Unhide Sheet. If Unhide is unavailable, Excel does not currently have a normally hidden worksheet to show, or a restriction is preventing the change.

Excel allows a workbook to contain hidden worksheets that are not shown in the tab strip. Hiding a sheet does not delete its data, formulas, or charts; it simply removes the sheet from ordinary view. For example, a workbook might hide a calculation sheet used by a dashboard while leaving the dashboard and report tabs visible. Unhiding can be useful, but check with the workbook’s owner before changing a file designed for a particular workflow.

There is also a less obvious state called VeryHidden, which is generally set through Visual Basic for Applications rather than the regular Unhide dialog. A VeryHidden sheet will not appear in that dialog. If a sheet is expected but does not appear there, ask the workbook’s creator or administrator before investigating VBA settings. Do not enable or run unfamiliar macros just to recover a tab.

Check workbook protection and editing access

Workbook structure protection can prevent users from inserting, deleting, moving, renaming, hiding, or unhiding sheets. It does not usually explain a completely missing tab strip by itself, but it can explain why the Unhide command is disabled or why Excel will not let you restore a particular sheet. Check Review > Protect Workbook for the workbook-structure protection control. If protection is active, you may need the password or assistance from the person who maintains the workbook.

Read-only access and Protected View are different issues. A read-only workbook can still display its sheet tabs; it simply limits saving changes to the original file. Protected View may restrict editing until you choose to enable it, but it is not the usual cause of a blank tab area. Avoid changing security settings or downloading a second copy from an untrusted source just because tabs are missing.

If the workbook is shared, stored in a managed location, or controlled by an organization, the owner may have intentionally protected its structure. Ask whether a sheet is supposed to be visible before altering protection or trying to recover a hidden sheet. This avoids confusing a deliberate design choice with a display fault.

Excel for Mac and Excel for the web

Menu names and placement differ across platforms. In Excel for Mac, check the application’s Excel > Settings or Excel > Preferences menu, depending on the release, and look in the View settings for the sheet-tab display option. Microsoft has changed some settings labels and locations between Mac releases, so use Excel’s settings search, if available, or its Help search for “sheet tabs” if the wording differs. You can also check whether the workbook window is too narrow or the horizontal scrollbar is covering most of the tab area.

Excel for the web uses a browser-based interface, so it does not have the Windows File > Options dialog. Check the workbook’s bottom edge for the tabs and tab-navigation controls, and use the available sheet commands to unhide a worksheet if needed. If you cannot change a setting or a workbook is protected, open it in the desktop app if you have access, or ask its owner. The web version’s controls can vary as Microsoft updates the interface.

When asking for help, mention which version you are using and whether the entire tab strip is missing or just one sheet. That distinction quickly narrows the likely cause and helps someone give you the right menu path.

When the usual fixes do not work

If Show sheet tabs is enabled and the tab strip remains absent, check the workbook window and then test whether the issue is limited to one file. Open a different workbook in Excel. If its tabs appear, the problem is likely a setting or protection state specific to the original workbook. If no workbook shows tabs, close and reopen Excel, then check the display setting in another file and confirm that the application is up to date.

  • Save a separate copy before experimenting. Use File > Save As and give the copy a new name. This preserves the original if a setting or sheet change has an unexpected effect.
  • Check the correct workbook. The Advanced settings section can refer to a selected open workbook, so verify that you are changing the file with the problem.
  • Look for a hidden sheet, not just a hidden tab bar. If other tabs are visible, use Unhide and check the list of sheet names.
  • Ask the file owner before changing protected content. A hidden sheet can contain formulas or supporting data that a report depends on.

Do not assume that the workbook is corrupt simply because tabs are missing. A changed display option, a narrow tab area, or a hidden worksheet is much more straightforward to check first. If the file behaves unusually in several ways, such as failing to open or showing errors, work from a copy and contact the person who supplied it before attempting repairs.

Prevent sheet-tab confusion

When preparing a workbook for other people, keep the visible sheets clearly named and leave enough space for the tabs. If some sheets are intentionally hidden, document their purpose in a visible instruction sheet or in the workbook’s accompanying notes. This is especially helpful in dashboards and templates, where hidden calculation sheets may be part of the design.

If someone reports that all tabs vanished, ask whether they can see any tabs in other workbooks. If they can, direct them first to the workbook-specific Show sheet tabs option. If they can see other tabs in the same workbook, guide them to the Unhide command instead. This simple distinction prevents changing a global-looking display feature when only one worksheet is involved.

Frequently Asked Questions

Why are all the sheet tabs missing in Excel?
Most often, Show sheet tabs has been turned off for that workbook, or the tab strip is squeezed out of view. In Windows Excel, check File > Options > Advanced > Display options for this workbook, then select Show sheet tabs.

How do I get one missing sheet tab back?
Right-click a visible tab and choose Unhide, select the sheet, and click OK. If there are no visible tabs, restore the full tab strip first. A VeryHidden sheet will not appear in the standard Unhide list.

Why is Unhide greyed out in Excel?
There may be no normally hidden worksheets, or workbook structure protection may prevent changes. If you expect a particular sheet, ask the workbook owner whether it is protected or set to VeryHidden.

Can I restore sheet tabs without changing the worksheet data?
Yes. Turning on Show sheet tabs changes how the workbook is displayed, not the contents of its cells. Unhiding a worksheet makes its existing contents visible; it does not recreate deleted data.

Why do sheet tabs show in one workbook but not another?
The Show sheet tabs option can be set separately for each workbook. Check the setting while the affected file is selected, and make sure the Advanced options refer to that workbook rather than another open file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.