Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Show Ruler in Excel (with Simple Steps)

Rulers are used to measure the height and width of cells in Excel. We can do this from the format section of the Home tab. But every time measuring the height and width of cells is very time-consuming. There is a solution to this problem. We can enable the ruler option to measure the height and width easily. Here, we will discuss how to show the ruler in Excel and other properties of the ruler with proper explanations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


How to Show and Use Ruler in Excel

1. Showing Ruler in Excel

In this first section, we will show all the steps to show the ruler in Excel. Look at the below steps.

📌 Steps:

  • Go to the View tab of Excel.
  • Click on the Page Layout option from the Workbook Views group.

  • We can see the Ruler option is showing in the Show group.

Showing ruler in Excel from the View tab

  • Look at the dataset.

Showing ruler in the worksheet

We can see the ruler is showing horizontally and vertically. We can measure the length or width of any cell from this ruler.

Read More: [Fixed!] Excel Ruler Not Showing (With Easy Solution)


2. Change Ruler Units

We can change the unit of the ruler according to our desire. The default unit is Centimeter. We want to change this into a millimeter.

📌 Steps:

  • Go to File >> Options >> Advanced.
  • Find out the Display option by scrolling the status bar.
  • Now, choose Millimeters from the Ruler units section.

Change unit of ruler in Excel

  • Finally, press the OK button and look at the dataset.

Here, the ruler is shown in the millimeter scale.

Read More: How to Display Document Properties in Excel (3 Simple Methods)


Similar Readings


3. Remove Ruler from Excel

In this section, we will show how to remove the ruler from Excel.

📌 Steps:

  • Go to the View tab of Excel.
  • Untick the Ruler option from the Show group.

The ruler will be removed from the dataset.

Read More: How to Remove Last Modified By in Excel (3 Ways)


What Is the Use of Ruler in Excel?

Here, we will show how to use the ruler to measure the height or width of any cell.

  • Move the cursor to the ending edge of a cell in the heading section.
  • We will see a symbol, marked by a round shape.

We can see the width of the cell with pixels in the heading section. In this way, we can easily measure the length or width of a cell. We can also resize the cell by moving it in the symbol’s left or right direction.


How to Fix If Ruler Is Greyed Out in Excel

Previously we demonstrated how to show the ruler in Excel. But, sometimes it is seen that the ruler option is grayed out.

This is because the workbook is in Normal mode.

Ruler grayed out

To enable the Ruler option, click on the Page Layout option. The Ruler will be visible after that.


Conclusion

In this article, we described the full process of how to show the ruler in Excel, how to change the unit, remove the ruler, and how to use the ruler in Excel. I hope this will satisfy your needs. Please have a look at our website ExcelDemy and give your suggestions in the comment box.


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo