Office Settings & Configuration

Restore the Horizontal Ruler and Header View in Excel

Steve KSteve K Nov 22, 2026 868 views

Question details

The user wants to restore the horizontal ruler and expected header view in an Excel worksheet.

Restore the Horizontal Ruler and Header View in Excel
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.
Before you start

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.

Solution 1Recommended

Select Page Layout View and Show the Ruler

Use Page Layout view when you need to see the ruler and page headers.

1
Open Page Layout view

Select the affected worksheet, then go to View > Page Layout.

2
Show the ruler

On the View tab, select Ruler in the Show group if it is not already checked.

3
Check the page header

Look at the top of the page in Page Layout view. Click the header area to view or edit its contents.

4
Check worksheet headings

If the missing headers are row numbers or column letters rather than page headers, select View > Headings.

Select Page Layout View and Show the Ruler
Page headers and worksheet headings differ: Page headers appear at the top of printed pages. Worksheet headings are the row numbers and column letters around the grid.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesPrepare spreadsheet pages for printingUse a familiar interface for spreadsheet tasksMove existing workbooks into a free, lightweight office suite
microsoft office alternative - wps office

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.