Row Height Units in Excel: How to Change?

Get FREE Advanced Excel Exercises with Solutions!

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 is only 15. But there’s no row height unit 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 you can actually change them.


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. You can also use the Row Height dialog box to change the row height in Excel. Just type the desired height and press OK.

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


Download the Practice Workbook

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


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.


Related Articles


<< Go Back to Row Height | Rows 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.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo