Site icon The Teacher Point

Missing Sheet Tabs in Microsoft Excel

Missing Sheet Tabs in Excel 2016 / 2019

If you ever find “Missing Sheet Tabs” from the bottom left corner of your Microsoft Excel window, then here are a few causes and solutions that can help you to overcome the problem.

Show Sheet Tabs Option – Reason 1

Microsoft Excel lets you configure that either you want to Hide or Show the Sheet Tabs at the bottom left corner near the Horizontal Bar.

Figure 1.1
File – Options – Advanced
Figure 1.2
Advanced – Display Options for this workbook – Show Sheet Tabs

Excel Horizontal Bar Size – Reason 2

Another possible reason for Missing Sheet Tabs could be the horizontal bar that you see near the Sheet Tabs.

Figure 1.3
A wider Horizontal Bar can also hide Sheet Tabs
Figure 1.4
Adjust the Horizontal Bar size to reveal Sheet Tabs

Windows Taskbar and Restored Excel Window – Reason 3

Figure 1.5
Windows Taskbar is on top of Excel Sheet Tabs as the Excel window is Restored
Figure 1.6
Maximizing the Excel Window to reveal Sheet Tabs behind Window Taskbar

A Hidden Excel Workbook – Reason 4

Figure 1.7

Tip: If only one or more particular Sheets are missing from the Sheet tab then those worksheets might be individually hidden. From the Home tab – click Format drop-down button – under the Visibility section – point to Hide & Unhide – and then click on Unhide sheet. A list of hidden worksheets will appear. Select the worksheet you want to unhide and then click OK.

Figure 1.8

Before, you try any of the above methods to recover the Missing Sheet Tab, use CTRL+Page Up or CTRL+Page Down to identify if you can switch between sheets using the keyboard shortcut. That will help you to identify which of the above method can work for you.

I hope you got The Teacher Point.


Watch How To Recover Missing Sheet Tabs in Excel Tutorial


Exit mobile version