How to Show Ruler in Excel (with Simple Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Show and Use Ruler in Excel: 3 Simple Steps

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


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.


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.


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.


Download Practice Workbook

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


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 give your suggestions in the comment box.


Related Articles


<< Go Back to Workbook Views | Workbook in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo