Microsoft Excel Tabs missing or not showing [Fix]

Open an Excel worksheet, and then suddenly you notice that the tabs are missing, with no idea how to fix this issue. In this tutorial, we will discuss the cause of missing tabs in an Excel worksheet and how to locate them so that they can be visible in your workbook again.

Why are the Excel worksheet tabs missing?

Usually, when you open an Excel workbook, you will see some tabs at the bottom of your worksheet, but in some cases, your tabs may go missing due to some changes in your Excel settings. Below we have some causes on why your Excel sheet is missing.

• The size of the window keeps the tabs hidden.
• The show sheet tabs settings are turned off.
• The tabs get obscure due to the horizontal scroll bar.
• The worksheet itself is hidden.

Microsoft Excel Tabs missing or not showing

If Tabs are missing or not showing in your Excel worksheet, it may be due to some changes within your Excel settings. Take these steps to fix the issue.

1. Maximize your window
2. Turn on sheet tabs settings
3. Drag the double-headed arrow on the scrollbar horizontally
4. Unhide the worksheet

1] Maximize your window

Sometimes when users restore multiple windows in Excel, the windows will overlap each other. For instance, the top of an Excel window will cover the bottom of another Excel window hiding its tab. The solution to this issue is to maximize the window.

If maximizing the window does not work, then click the View tab.

Then select Arrange All in the Window group.

An Arrange Windows dialog box will open; click the Tile option.

Then click OK.

If the tabs are still missing, follow the other solution below.

2]Turn on sheet tabs settings

Ensure that the show sheet tab settings are enabled. Follow the steps below.

Click the File tab.

Click Options in the backstage view.

An Excel Options dialog box is open.

Click Advanced on the left pane.

Under the section “Display options for this workbook,” on the right, check the checkbox for Show sheet tabs.

Then click OK.

If the tabs are still missing, follow the other solution below.

3] Drag the double-headed arrow on the scrollbar horizontally

At the bottom of your Excel worksheet, hover your cursor at the edge of the scrollbar until you see a double-headed arrow.

Then click and drag the arrow to the right until you see the missing tabs.

If the tabs are still missing, follow the other solution below.

4] Unhide the worksheet

To unhide your worksheet tab, right-click on any visible tabs and select Unhide from the context menu.

An Unhide dialog box will open.

In the dialog box, select the tab that you want to unhide.

then click OK.

We hope this tutorial helps you understand how to find missing tabs in Microsoft Excel.

If you have questions about the tutorial, let us know in the comments.

Read: How to create and run Macros in Microsoft Excel.