Restore Missing Row Headers and Sheet Tabs in Excel
Question details
Restore row headers and worksheet tabs that are missing from one Excel workbook.

- 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.
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.
Create and Save a New Workbook Window
Use this method first when the affected workbook window may be displaying incorrectly.
With the affected workbook active, select View > New Window.
In the new window, select File > Save or press the Save button.
Close the workbook windows, reopen the file from File > Open, and check whether the row headers and sheet tabs are visible.

Check Excel Display Settings and Window Visibility
Use these settings if a new window does not restore the missing headers or tabs.
Test Excel in Safe Mode or Repair the Workbook
Try these checks if the display issue persists after resetting the window and checking its settings.
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.

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.




