Fix Missing Worksheet Tabs in an Excel Workbook
Question details
The user needs to restore worksheet tabs that are missing from one Excel workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Worksheet tabs appear in other workbooks but not in the current workbook.
- Observed behavior
- The current workbook's sheet tabs are not visible at the bottom of the window.
Open the affected workbook and confirm that its tabs are missing while tabs appear in another workbook. Check whether the affected workbook has split panes or a window that is not fully visible.
Adjust the Excel workbook window and split panes
Use this solution when tabs are missing from one workbook and its window layout or split panes may be hiding them.
Maximize or restore the Excel workbook window and check whether the sheet tabs appear along the bottom.
If a vertical split leaves only a narrow pane on the left, drag the split divider toward the middle of the worksheet. Alternatively, select View > Split to remove the split.
Select View > Arrange All, check Windows of active workbook if available, choose an arrangement, and select OK. Then check the bottom of the workbook window.
If the horizontal scroll bar takes up most of the bottom edge, drag the divider at its left end to the right to make more room for sheet tabs.

Enable sheet tabs for the affected Excel workbook
Check the workbook-specific display setting if adjusting the window and panes does not reveal the tabs.
Open Excel workbooks in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for an easy transition; it does not change Excel's display settings.

Frequently Asked Questions
Why are sheet tabs missing in only one Excel workbook?
The affected workbook may have a different window layout, split-pane position, or workbook-specific display setting. Check View > Split and File > Options > Advanced for that workbook.
Where is the Show sheet tabs setting in Excel?
Select File > Options > Advanced. Under Display options for this workbook, select the affected workbook and check Show sheet tabs.
Can a split pane hide worksheet tabs?
A vertical split positioned far to the left can leave too little room for the tab area. Drag the split toward the middle, or select View > Split to remove it.
What if the horizontal scroll bar covers the tab area?
Drag the divider at the left end of the horizontal scroll bar to the right to give the sheet tabs more space.




