Office Settings & Configuration

Fix Missing Worksheet Tabs in an Excel Workbook

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

The user needs to restore worksheet tabs that are missing from one Excel workbook.

Fix Missing Worksheet Tabs in an 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.
Before you start

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.

Solution 1Recommended

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.

1
Resize the workbook window

Maximize or restore the Excel workbook window and check whether the sheet tabs appear along the bottom.

2
Check the split

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.

3
Arrange workbook windows

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.

4
Adjust the scroll bar

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.

Adjust the Excel workbook window and split panes
Free Microsoft Office alternative

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.

Work with multiple worksheets using sheet tabsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceMove existing workbooks to a lightweight office suite
microsoft office alternative - wps office

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.