Why Excel Row Height Shows 14.4 or 10.1 and How to Fix It
Question details
The user wants to understand why Excel row heights automatically change to fractional values like 14.4 or 10.1 when an integer is entered, and how to set precise row heights.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adjusting row heights for precise formatting, layout alignment, or printing preparation.
- Observed behavior
- When entering a specific integer value for a row height, Excel converts and displays the value as a decimal (e.g., 14.4 or 10.1).
Verify your current workbook's default font and your monitor's display scaling settings, as these directly dictate how row heights are calculated and rendered in points.
Adjust Default Font and Manually Set Row Height
Change the default font settings that influence row height calculations and apply a custom row height directly through the formatting menu.
Excel measures row height in points. Because these point sizes are tightly bound to the default font (often Calibri 11) and your monitor's DPI scaling, exact integer inputs might be automatically converted to fractional decimals like 14.4 or 10.1.
These automatic conversions ensure the text remains fully readable on your specific display. Small fractional differences are completely normal and rarely impact the printed layout of your document.
Go to File > Options > General to review or change your workbook's default font style and size.
Highlight the specific rows you want to adjust by clicking and dragging across the row numbers on the left side of the sheet.
Navigate to the Home tab, click on Format in the Cells group on the ribbon, and select Row Height from the dropdown menu.
Enter your desired numeric value in the dialog box and click OK. Keep in mind that minor automatic rounding by the software is normal.
Set Precise Row Heights Easily in WPS Spreadsheet
WPS Spreadsheet provides intuitive formatting tools to help you adjust row heights and column widths with precision, ensuring your tables look perfect both on-screen and when printed.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Select the rows to resize: Click and drag on the row headers (the numbers on the left) to select the rows you wish to adjust.
- 3. Access the Row Height tool: Right-click the selected row headers and choose 'Row Height' from the context menu, or navigate to the Home tab and click 'Rows and Columns'.
- 4. Enter the exact height value: Type your preferred height value in points in the dialog box and click OK to apply the changes instantly.
Frequently Asked Questions
What unit of measurement is used for Excel row heights?
By default, Excel measures row height in points. One point is approximately 1/72 of an inch. The standard row height depends on the default font size set in the workbook.
Why does my row height change automatically when I type?
Excel automatically adjusts row heights to accommodate the largest font size or multiple lines of text within that row. If you apply text wrapping or change font styles, the row height adapts to prevent text from being cut off.
How can I set row height in inches or centimeters instead of points?
You can change the measurement unit by switching to Page Layout view. Go to View > Page Layout. When you drag the row boundaries or enter a specific measurement in the Row Height dialog box, it will now use your system's default measurement units (like inches or centimeters).
Will a row height displaying as 14.4 instead of 15 ruin my printed page?
No, a minor fractional difference like 0.6 points is visually imperceptible (less than 1/100 of an inch) and will not significantly impact the layout, page breaks, or alignment of your printed document.
