Enable the Horizontal Ruler in Excel 2016 Page Layout View
Question details
The user wants to use the horizontal ruler and adjust text alignment in Excel 2016.

- 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.
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.
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.
Click the Page Layout view button in the bottom-right view controls, or select View > Page Layout.
On the View tab, select Ruler in the Show group if it is not already selected.

Adjust cell text with alignment and indentation controls
Use cell formatting controls when your goal is to position text inside a cell.
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.

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.




