Office Settings & Configuration

Enable the Horizontal Ruler in Excel 2016 Page Layout View

Camila MilosovichCamila Milosovich Nov 22, 2026 868 views

Question details

The user wants to use the horizontal ruler and adjust text alignment in Excel 2016.

Enable the Horizontal Ruler in Excel 2016 Page Layout View
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
The user is working in Normal view and wants a ruler to help format text in individual cells.
Observed behavior
The Ruler option may be checked but is unavailable in Normal view. The ruler works in Page Layout view but cannot align text within individual cells.
Before you start

Open the worksheet and check the current view using the view controls at the bottom right. The ruler is available in Page Layout view, not Normal view.

Solution 1Recommended

Display the ruler in Excel 2016 Page Layout view

Use Page Layout view to display the horizontal ruler for page layout, rather than cell text alignment.

1
Switch views

Click the Page Layout view button in the bottom-right view controls, or select View > Page Layout.

2
Show the ruler

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

Display the ruler in Excel 2016 Page Layout view
Ruler limitation: Excel 2016 does not provide this ruler in Normal view, and the Page Layout ruler does not align text within individual cells.
Free Microsoft Office alternative

Format Spreadsheet Text with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet files. Use WPS Spreadsheet's cell alignment controls when formatting text; it does not change Excel 2016's ruler behavior.

Adjust cell text alignment and indentation in WPS SpreadsheetOpen and edit Microsoft Excel XLS and XLSX filesNavigate a familiar spreadsheet interfaceMove existing spreadsheet work to a lightweight, free Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why is the ruler unavailable in Excel 2016 Normal view?

Excel 2016 displays the ruler in Page Layout view, not Normal view. Select View > Page Layout to use it.

How do I show the ruler after switching views?

Open the View tab and select Ruler in the Show group while the worksheet is in Page Layout view.

Can I use the Page Layout ruler to align text inside a cell?

No. Select the cell and use the Home tab's Alignment controls or right-click it and choose Format Cells > Alignment.

How can I indent text in an Excel cell?

Select the cell, then click Increase Indent in the Home tab's Alignment group. You can also use the Alignment tab in Format Cells.