Restore the Horizontal Ruler and Header View in Excel
Question details
The user wants to restore the horizontal ruler and expected header view in an Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to work with a worksheet's ruler and page headers.
- Observed behavior
- The horizontal ruler is missing or the header view appears different than expected.
Open the affected workbook and select the worksheet with the display issue. Check whether other worksheets in the workbook show the ruler and headers as expected.
Select Page Layout View and Show the Ruler
Use Page Layout view when you need to see the ruler and page headers.
Select the affected worksheet, then go to View > Page Layout.
On the View tab, select Ruler in the Show group if it is not already checked.
Look at the top of the page in Page Layout view. Click the header area to view or edit its contents.
If the missing headers are row numbers or column letters rather than page headers, select View > Headings.

Inspect Macros That Change the Worksheet Display
Check workbook and worksheet code if the view changes again or only one worksheet is affected.
Copy the Data to a New Worksheet
Try a fresh worksheet if the display issue persists on one sheet.
Work With Spreadsheet Pages in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for editing spreadsheets and preparing pages for printing. Its Excel format support makes it easy to move existing workbooks into WPS, although it does not repair Excel's display settings.

Frequently Asked Questions
Why is the ruler missing in Excel?
The ruler is available in Page Layout view. Select View > Page Layout, then check Ruler on the View tab.
How do I see or edit a page header in Excel?
Select View > Page Layout, then click the header area at the top of the page to see or edit its contents.
How do I restore row numbers and column letters?
On the View tab, select Headings. These worksheet headings are different from the page header used for printing.
Can a macro change the worksheet view?
Yes. Workbook or worksheet event code can change display settings. Open Developer > Visual Basic and inspect the relevant code if the view keeps changing.
Will copying cells to a new sheet also copy the page header?
Not necessarily. After using the plus button to create a worksheet and pasting the cells, check its page setup and recreate the header if needed.




