Excel Worksheet Tabs Not Visible? How to Restore Them

How-to basics · Updated November 18, 2026

If Excel worksheet tabs are not visible, first check File > Options > Advanced and turn on Show sheet tabs under “Display options for this workbook.” If that setting is already on, check whether the sheets are hidden or the horizontal scrollbar has squeezed the tab area out of view.

Check the workbook’s sheet-tab setting

In Excel for Microsoft 365 on Windows, open the affected workbook and follow these steps:

  1. Select File > Options.
  2. Choose Advanced.
  3. Scroll to Display options for this workbook. If more than one workbook is open, confirm the correct workbook is selected in the drop-down.
  4. Select Show sheet tabs, then click OK.

This option controls whether the workbook’s worksheet-tab bar appears at the bottom of its window. It does not unhide an individual worksheet: a sheet can remain hidden even while the tab bar is enabled. The setting is specific to the selected workbook, so changing it for one open file does not necessarily change it for another.

If the box was already selected, turn it off, click OK, then return to the same setting, turn it back on, and click OK. This can help refresh the display. If the setting is unavailable or the tabs remain missing, continue with the checks below rather than assuming the workbook has lost its data.

Unhide worksheets that are hidden

If at least one worksheet tab is visible, a particular missing sheet may simply be hidden. In Windows Excel, right-click a visible sheet tab and choose Unhide. Select the worksheet name in the list and click OK. You can also use Home > Format > Hide & Unhide > Unhide Sheet.

Excel shows a list of sheets that can be unhidden. If the name you expect is not in the list, check that you have the right workbook open; the sheet may have been deleted, renamed, or hidden using a method that the ordinary Unhide command cannot reverse. Excel’s standard interface allows only one worksheet at a time to be unhidden this way, so repeat the command if several are listed.

A worksheet set to “VeryHidden” through VBA does not appear in the Unhide list. That is different from the usual Hide command and typically requires someone to change the sheet’s visibility property in the Visual Basic Editor. If the workbook came from another person or contains macros, ask its owner or administrator before changing code or security settings. Do not enable unknown macros just to make a tab appear.

Make room beside the horizontal scrollbar

At the bottom of an Excel window, worksheet tabs and the horizontal scrollbar share limited space. If the scrollbar has been expanded, it can occupy nearly all the available width, leaving the tabs difficult to see or apparently missing. Look for the narrow divider between the sheet-tab area and the scrollbar. Drag it to the right to give the tabs more room; the scrollbar will become shorter.

Also check the bottom-left corner for the small sheet-navigation arrows. They scroll through the tabs when a workbook has too many sheets to display at once; they do not hide or delete worksheets. If tabs are present but off-screen, use those arrows to move along the tab strip. In many desktop versions, right-clicking the navigation controls opens a list of sheet names, which can help you jump to a sheet without scrolling through every tab.

Changing the window size can expose tabs as well. Maximize the Excel window, widen it, or close panes and side panels that take up space. A narrow window is especially noticeable in workbooks with many long sheet names. If the scrollbar divider is hard to locate, maximize the window first and inspect the bottom edge again.

Confirm you are looking at worksheet tabs

Excel has more than one kind of “tab.” Worksheet tabs are the named items along the bottom of the workbook, such as January, Summary, or Data. Ribbon tabs—such as Home, Insert, and Formulas—are at the top. If the ribbon is minimized or hidden, that is a separate display issue and does not explain missing worksheet tabs.

Similarly, hiding the ribbon, changing the zoom level, or freezing rows and columns does not normally hide worksheet tabs. Freeze Panes affects which rows and columns stay visible while you scroll within a sheet. It does not control the tab bar. Avoid changing unrelated settings when the problem is specifically at the bottom of the workbook window.

Make sure you are in the expected workbook window, too. With multiple workbooks open, it is easy to inspect one file while expecting the sheets from another. The workbook title appears in Excel’s title bar, and each workbook can have its own worksheets and display settings.

Check the workbook view and window layout

If the sheet-tab option is enabled but the bottom of the window still looks unusual, switch back to the standard worksheet view using View > Normal. Other workbook views can change how the sheet is presented, although they should not ordinarily remove the tabs when the display setting is on.

Look for a window or layout issue rather than a damaged file. For example, a workbook window may be very small, a dialog may be covering the lower edge, or the Excel application may have been resized so that the bottom controls are outside the visible area. Maximize Excel, close any open dialog, and check the bottom border. If the workbook is open in a remote desktop session or on a display with unusual scaling, resizing the window or adjusting the display layout may reveal controls that are clipped.

Workbook protection is not the same as hiding sheet tabs. Protecting a worksheet limits certain edits, while protecting workbook structure can restrict actions such as adding, deleting, moving, hiding, or unhiding sheets. Protection may explain why an Unhide command is unavailable, but it does not normally switch off the tab bar itself. If a command is disabled, check Review for workbook-structure protection or ask the file owner for permission.

Differences on Mac and Excel for the web

In Excel for Mac, the wording and location of settings can vary by release. Look under Excel > Settings (or Excel > Preferences in some releases), then open View and look for the sheet-tab option under window display settings. To reveal a hidden sheet, use the sheet-tab context menu and choose Unhide, or look for the Unhide command on the Home ribbon. The Windows path File > Options > Advanced does not apply to Mac.

In Excel for the web, worksheet tabs appear along the bottom of the workbook, but the Windows desktop Options dialog is not available. Widen the browser window, reduce browser zoom if the page is crowded, and use the visible tab-navigation controls to reach sheets farther along the strip. To unhide a worksheet, use the available sheet-tab context menu or ribbon command. If a setting or command is missing in the web version, open the file in the Excel desktop app and check there; some workbook and display controls differ between the web and desktop versions.

On both Mac and web, a narrow viewport can make a tab strip look incomplete. Browser sidebars, a docked panel, or a small application window may reduce the room available for sheet names. First maximize the window and inspect the entire bottom edge before concluding that a worksheet has disappeared.

A quick way to narrow down the cause

Use the visible clues to choose the next step instead of making several unrelated changes:

  • No worksheet tabs at all: Check Show sheet tabs in the workbook’s display settings, then examine the window width and scrollbar divider.
  • Some tabs show, but one expected name does not: Right-click a tab and choose Unhide. Confirm the workbook is the correct one.
  • Tabs appear to stop after a few names: Use the navigation arrows or widen the tab area by moving the scrollbar divider.
  • Unhide is unavailable: The workbook structure may be protected, or the sheet may be VeryHidden. Check with the workbook owner rather than changing code or protection without authorization.
  • The bottom edge is cut off: Maximize the application, close dialogs, and adjust the window or display layout.

These checks also help distinguish a display problem from a missing worksheet. A hidden worksheet generally still exists in the workbook, while a deleted sheet cannot be restored with the Unhide command. If the file is important, make a separate copy before attempting structural changes, and use version history or a backup if deletion is suspected.

Frequently Asked Questions

Why did all my Excel worksheet tabs disappear?
Most often, Show sheet tabs was turned off for that workbook, or the scrollbar/window layout left no visible room for the tabs. Check File > Options > Advanced on Windows, then inspect the bottom of the window.

How do I show a hidden sheet in Excel?
Right-click a visible worksheet tab, select Unhide, choose the sheet, and click OK. You can also use Home > Format > Hide & Unhide > Unhide Sheet.

Why is Unhide greyed out in Excel?
There may be no ordinarily hidden worksheets, or workbook structure protection may prevent changes. A VeryHidden worksheet also will not appear in the standard Unhide list. Ask the workbook owner before changing protection or VBA settings.

Can I restore a sheet tab without opening the file in desktop Excel?
Often you can use the sheet-tab context menu in Excel for the web to unhide a sheet, but the web version does not include every desktop setting. If the entire tab bar is disabled or a command is unavailable, open the workbook in the desktop app and check its display options.

Does hiding the ribbon hide worksheet tabs too?
No. The ribbon is at the top of Excel and the worksheet tabs are at the bottom. Ribbon display settings and the Show sheet tabs workbook option control different parts of the interface.

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.