Office Settings & Configuration

Restore Missing Row Headers and Sheet Tabs in Excel

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

Restore row headers and worksheet tabs that are missing from one Excel workbook.

Restore Missing Row Headers and Sheet Tabs in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to view row headers and switch between worksheets in an existing workbook.
Observed behavior
Row headers and sheet tabs appear in new workbooks but not in one specific file.
Before you start

Open the affected workbook and compare it with a new workbook to confirm whether the display issue is limited to one file. Make sure the affected workbook is active before changing its display settings.

Solution 1Recommended

Create and Save a New Workbook Window

Use this method first when the affected workbook window may be displaying incorrectly.

1
Open a new window

With the affected workbook active, select View > New Window.

2
Save the workbook

In the new window, select File > Save or press the Save button.

3
Reopen the file

Close the workbook windows, reopen the file from File > Open, and check whether the row headers and sheet tabs are visible.

Create and Save a New Workbook Window
Same workbook, two windows: New Window opens another view of the same workbook, not a separate copy.
Free Microsoft Office alternative

Open Excel Workbooks in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue working while keeping migration straightforward. It does not repair Excel's own window settings.

Open and work with Microsoft Excel XLSX and XLS filesView and navigate worksheets in WPS SpreadsheetUse a familiar spreadsheet interfaceMove existing Office files into a lightweight, free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why are row headers missing in only one Excel workbook?

The affected worksheet may have its headings disabled, or the workbook window may be displaying incorrectly. Check File > Options > Advanced > Display options for this worksheet, or try View > New Window.

Where is the setting for Excel sheet tabs?

With the workbook active, go to File > Options > Advanced. Under Display options for this workbook, enable Show sheet tabs and select OK.

Does View > New Window create a copy of my workbook?

No. View > New Window opens another window for the same workbook. Save the workbook in the new window, then close and reopen it to check the display.

How can I check whether an add-in is causing the display issue?

On Windows, close Excel, press Windows+R, enter excel /safe, and open the workbook. If it displays correctly in Safe Mode, investigate add-ins and startup customizations.

What should I do if the workbook still does not display correctly?

Make a copy of the file, then choose File > Open > Browse in Excel. Select the workbook and use the arrow next to Open to choose Open and Repair.