What If Excel Tabs Are Not Showing on Bottom? 4 Tips!

Excel Sheets Not Showing

In Windows 11/10, Microsoft Excel is a useful spreadsheet app that meets your many needs, including calculation, graphing, answering statistical, engineering, financial, etc. You may create many Excel files at work.

Related post: Get Microsoft Office Free Download for Windows 10!

However, sometimes you find sheets in your Excel file are not showing up on the bottom. Is the Excel file lost or deleted? Actually, this file still exists but Excel tabs don’t display. Potential reasons for this may include:

• The horizontal scroll bar masks the tabs
• You hide the worksheet itself
• You disable Display options for this workbook
• The workbook window is sized in a way that the tabs are hidden
• Restoring the multiple Excel windows and then moving the worksheet window
• The screen resolution might be too large that Excel tabs disappeared from the screen

Next, let’s see how to fix Excel tabs not showing via some methods.

Fix 1: Check Excel Windows Sizing

Sometimes you don’t know you have opened many windows in Excel, leading to tabs on the current worksheet to be shrouded. In this case, you should check the top of one window to see if it covers the sheet tabs of another window.

Besides, maximize the Excel window by double-clicking on the title bar to see all the sheets.

Fix 2: Show Sheet Tabs

If an Excel file opens but does not display, you should check the settings in Excel. As is well known, there should be a sheet when opening an Excel workbook and you can see at least a tab on the bottom. If you can’t see tabs in Excel, perhaps the setting is incorrect.

To do this:

Step 1: Click on the File tab at the top and choose Options.

Step 2: Under the Advanced tab, scroll down to find the Display options for this workbook menu.

Step 3: Check the box of Show sheet tabs.

Fix 3: Unhide the Worksheet

Excel tabs not showing may appear since you hide them. When hiding a sheet in Excel, it still exists as a part of the workbook but you cannot see the tab. So, go to check and unhide the sheet tabs.

Step 1: Right-click on any existing sheet tab and choose Unhide from the context menu.

Step 2: In the popup, choose the sheet you want to unhide and click OK. Do this operation for all the sheets you want to show. Then, the hidden tabs appear in the workbook.

Fix 4: Change the Horizontal Scroll Bar

As stated above, Excel sheets not showing can arise because of the horizontal scroll bar. To solve this issue, follow the steps:

Step 1: Click on the three dots icon on the left of the scroll bar.

Step 2: When the mouse pointer turns a double-headed arrow, drag it to the right, and then you will see the sheet tabs.

Final Words

Are Excel tabs not showing? How to view tabs in Excel if they miss from the bottom? In this post, the given four solutions to Excel worksheet tabs missing are fairly helpful. If your Excel file opens but does not display, try them now.

Excel not showing sheets is a common case and your Excel file is not lost. But you should know that files can easily lose by accident. So to keep data secure, we strongly recommend backing up your Excel files using MiniTool ShadowMaker. To know the steps, follow the guide – How to Backup Excel Files in Windows 11/10? 3 Ways.

MiniTool ShadowMaker TrialClick to Download100%Clean & Safe