How to Fix Excel Tabs/Sheets Not Showing?

In Excel, all tabs (also known as sheets) are shown by default beneath the work area.

But don’t panic if you can’t see any tabs and wonder where it went. Your Excel workbook’s missing bills might have been caused by several factors.

In this post, I’ll outline a few techniques this post that you may employ to add the missing tabs to your Excel workbook.

If none of the tab names is visible, a setting probably needs to be adjusted.

And if specific sheet tabs are visible but not all of them, it’s conceivable that the sheets have been hidden, and you need to unhide them for them to become visible.

Another less likely but still plausible explanation is that the scrollbar is being used to conceal the sheet tabs (when more sheets extend beyond where the scrollbar starts)

Let’s examine each of these situations individually:

This instructional explains:

1. When every sheet tab is blank
2. When a few sheet tabs are removed
   2.1 A few of the sheets are obscured.
   2.2 As a result of the Scroll Bar, Tabs are Hidden

When every sheet tab is blank:

Even if it’s a brand-new blank workbook, every time you open an Excel workbook, there must be at least one sheet tab present.

If you are unable to view any tabs, you may need to alter a setting to make the tabs visible.

The ways to reactivate Excel’s tabs’ visibility are listed below:

Go to the File tab.
Select Options.
Click the Advanced option in the “Options” dialogue box that appears.
Scroll down to the box labeled “Display Options for this Workbook.”
Check the box next to “Show sheet tabs”

By adjusting as mentioned earlier, all of the workbook’s possible sheet tabs would be made visible (unless the user has specifically hidden some of the worksheets)

Keep in mind that this setting is workbook-specific,
so if you activate it in one of the workbooks,
it will only cause the tabs to reappear in that particular workbook.

When a few sheet tabs are removed:

Some of the tabs in the worksheet could occasionally be visible, while others might not be.

If only part of the tabs are missing and some are visible, I have various remedies in this area.

A few of the sheets are obscured.

The user has probably hidden some of the tabs in the worksheet, which is why you can’t view them.

When a worksheet in Excel is hidden, it remains a part of the Excel workbook, but the name of the sheet tab isn’t displayed with other sheet tabs.

You simply need to remove the sheets from hiding to fix this.

The steps to reveal one or more Excel sheets are shown below:

simply right-click any of the current sheet tab names.

Select “Unhide” from the menu. If the workbook doesn’t include any hidden sheets, this option will be greyed out.

Click the sheet name in the Unhide dialogue box to reveal it.

Click “OK”

The selected sheet would become visible again as a tab in your workbook once you completed the aforementioned procedures.

If you wish to unhide several sheets at once, you may do so in the "Unhide" dialogue box.
To accomplish this, click on the Sheet names you wish to make visible while holding down the Control key (or the Command key on a Mac). 
The sheets you click on will all be selected, and you may unhide them all with a single click.

However, what if the tab name is not among the names mentioned in the Unhide dialogue box?

The name of the sheet can be hidden in Excel so that it doesn’t appear in the Unhide dialogue box.

How do you then reveal these “extremely concealed” sheets?

You can read my lesson, in which I demonstrate how to reveal sheets that have been “extremely concealed,” here. It is simple and just requires a few clicks.

As a result of the Scroll Bar, Tabs are Hidden

A huge scroll bar that obscures the tabs may also be the source of your missing tabs.

Resize the scroll bar to make all other tabs visible, and it has a quick remedy.

Click and drag the three dots symbol to the right of the scrollbar to make the sheet tabs reappear. The scroll bar will be reduced, and all previously concealed sheet tabs will now be displayed.

Even if you decrease the scrollbar in a big workbook with several sheets, certain sheet tabs may still be obscured.

In this situation, you may make those sheet tabs visible by using the navigation icons (located to the left of the first sheet tab).

These are a few methods to resolve the problem when the sheet tabs are absent or not visible in Excel. The Excel Options dialogue box option probably needs to be adjusted if there are no sheet tabs visible in the worksheet.

If some sheet tab names are visible but some are not, you should determine whether the user has hidden any sheets or whether a long scroll bar has obscured them.