This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 33%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
I cannot figure out how to display ruler in Excel. Product is Office Home and Student 2019.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Answer recommended by moderator
The rulers are displayed in Page Layout mode. Go to View tab of the ribbon, click on “Page Layout” and check the Ruler checkbox.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 24%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Hi,
In Excel, there is no ruler feature like the one available in Word. This is normal behavior and not related to your Office version. Excel does not include a built-in ruler because it is spreadsheet-based rather than document-layout based.
If you need alignment guidance, you can use Gridlines (View → Gridlines) or switch to Page Layout view (View → Page Layout) to better see margins and print layout. However, a traditional horizontal and vertical ruler like in Word is not available in Excel, including in Office Home and Student 2019.
Page Layout view does have a ruler. See Viorel's Answer. The ruler can be shown or hidden in that view.
AI answer
To display the ruler in Excel, you can use the DisplayRuler property. This property is part of the Window class in the Microsoft.Office.Interop.Excel namespace. You can set it to true to show the ruler for the specified window.
Here’s a brief example of how you might set this property in C#:
Excel.Window window = ...; // your Excel window object
window.DisplayRuler = true; // This will display the ruler
Make sure that you have the correct references to the Microsoft.Office.Interop.Excel assembly in your project to use this functionality.
If you're using Excel directly without programming, you may need to check the view options in Excel to enable the ruler, as the method can vary slightly depending on the version of Excel you are using.