Row Height Units in Excel: How to Change?

If you want to adjust the row heights, there are several ways available that you can use. When you right-click on a row and go to the Row Height option to see the default value, you will find it only 15. But there’s no row height unit is showing up. You may wonder what the default row height unit is or even how to change the row height units. In this article, you will get to know about the default row height units in Excel and also how do you can actually change them.


Download the Practice Workbook

You can download the Excel file from the following link and practice along with it.


Default Row Height Units in Excel

The default row height unit is Inches.

Where 1 inch equals 96 pixels. In Microsoft Excel, 1 inch is divided into 72 DPI (Dots Per Inch). And the default value of the row height is 15 DPI.

If you want to check out this default value then,

❶ Select any row you want.

❷ Go to the Home tab.

❸ From the Cells group, choose Format.

❹ From the Format drop-down, click on the Row Height command.

Check Default Row Height Units in Excel

You can also avail of the Row Height option just by right-clicking on a row. Then a pop-up menu will appear. From the list, click on the Row Height. That’s it.

Shortcut to Check Default Row Height Units in Excel

After that, the Row Height dialog box will appear. In the box, you will see that the default row height is set to 15. But there’s no unit mentioned there. For those who are wondering about the unknown row height, it is Inches.

To be sure about the default row height unit,

❶ Go to the View tab first.

❷ Then from the Workbook Views group, click on the Page Layout command.

❸ After that, select a row and right-click on it. This will bring a pop-list.

❹ From the list, choose Row Height.

See Row Height Units in Excel

The Row Height dialog box will appear. Thus you will see the default row height is 0.21 inches. Which is in terms of DPI, 15. So, you see the default row height unit is Inches.

Read More: How to Change & Restore Default Row Height in Excel


Change Row Height Units from Excel Advanced Options

If you want to change the row height unit in Excel which is Inches by default, then  follow the steps below:

❶ First of all, go to the File tab from the main ribbon.

❷ Navigate to the Options.

Excel Options dialog box will appear. From the list of options, click on Advanced.

❹ Then go to the Display options.

❺ Then click on the Ruler Units drop-down. Then you will see,

  • Inches
  • Centimeters
  • Millimeters

❻ Choose any of the units from there.

The Default units mean Inches. But you can set the row height units to Centimeters or Millimeters as you like.

For instance, I’m choosing Millimeter from the Ruler units drop-down.

❼ Finally hit the OK button to save the settings.

Change Row Height Units in Excel

Now the Row Height Units are set to Millimeters. To check it out,

❶ Go back to the View tab.

❷ Click on Page Layout.

❸ Select any of the rows by clicking one of them.

❹ From the pop-up menu, select Row Height.

Check Row Height Units in Excel

Row Height dialog box will pop up. Now you can see that the row height unit has been set to millimeters.

So by following this process, you can change the Excel row height units to Inches, Centimeters, or Millimeters whatever you like.

Read More: How to Auto Adjust Row Height in Excel (3 Simple Ways)


Conclusion

To sum up, we have discussed steps to change row height units in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo