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.
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.
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.
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.
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,
❻ 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.
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.
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.
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.
- How to Increase Row Height in Excel
- Auto Row Height Not Working in Excel
- How to Copy Multiple Row Height in Excel
- How to Adjust Row Height to Fit Text in Excel