Excel Row Height in CM: Convert Points to Centimeters

How-to basics · Updated November 18, 2026

Excel measures row height in points, not centimeters. To convert it, multiply the point value by 2.54 and divide by 72: a 15-point row is about 0.53 cm tall, while 1 cm is about 28.35 points.

What Excel Row Height Measures

A point is a typographic unit equal to 1/72 of an inch. Since an inch is 2.54 cm, Excel’s row-height value can be converted to centimeters using the same ratio: points × 2.54 ÷ 72. The result describes the row’s height, not the height of its text or the width of its columns.

In Excel for Microsoft 365 on Windows, the Row Height dialog reports the value in points. There is no centimeters option in that dialog. The same point-based measurement is used in Excel for Mac and Excel for the web, although the available controls and their placement can vary slightly.

The default row height is commonly 15 points in a new workbook using Excel’s usual default font settings. That works out to about 0.53 cm. It is not a universal fixed default: workbook settings, the default font, and font size can affect the standard row height. A workbook can also contain rows with individually customized heights.

Convert Points to Centimeters

Use this conversion for any row-height value shown in Excel:

  • Centimeters = points × 2.54 ÷ 72
  • Points = centimeters × 72 ÷ 2.54

For example, 15 points × 2.54 ÷ 72 equals 0.529166… cm, which rounds to 0.53 cm. A height of 30 points is about 1.06 cm. In the other direction, 2 cm × 72 ÷ 2.54 is about 56.69 points.

If you want Excel to calculate a conversion in a worksheet, enter a row height in points in A2. With the point value 15 in A2, this formula returns approximately 0.5291667 cm:

=A2*2.54/72

For a result rounded to two decimal places, with the same layout and 15 in A2, use:

=ROUND(A2*2.54/72,2)

The result is 0.53. To convert centimeters back to points, enter a centimeter value in A2. With 1 in A2, this formula returns approximately 28.3465 points:

=A2*72/2.54

These formulas convert a number; they do not change a worksheet row’s actual height. To apply a height, use Excel’s row-height controls.

Useful Row-Height Conversions

This table gives approximate conversions for common values. The centimeter figures are rounded to two decimal places, so use the unrounded conversion when you need more precision.

  • 10 pt: 0.35 cm
  • 12 pt: 0.42 cm
  • 15 pt: 0.53 cm
  • 20 pt: 0.71 cm
  • 28.35 pt: about 1 cm
  • 30 pt: 1.06 cm
  • 40 pt: 1.41 cm
  • 72 pt: 2.54 cm

Excel allows row heights up to 409 points, equivalent to about 14.43 cm. The practical height you need is usually much smaller, but the limit matters if a pasted value or an unusually large font makes a row unexpectedly tall.

Set a Row to a Height Specified in Centimeters

Because Excel asks for points, convert the desired centimeter measurement first. For a target of 1.2 cm, calculate 1.2 × 72 ÷ 2.54, which is about 34.02 points. Enter 34.02 in the Row Height dialog to get approximately the requested size.

  1. Select the row or rows by clicking their row numbers along the left edge of the worksheet. To select adjacent rows, drag across the row numbers or select the first row and Shift-click the last.
  2. On the Windows ribbon, choose Home > Cells > Format > Row Height.
  3. Enter the converted value in points, then select OK.

You can also right-click a selected row heading and choose Row Height. Setting one value for several selected rows makes those rows the same height. It does not set an individual height for each cell: a row has one height shared across all its columns.

For a quick adjustment, move the pointer to the boundary below a row number and drag. Excel displays a height measurement as you adjust it. This is convenient for visual sizing, but entering a converted number in the dialog is more dependable when a specific measurement matters.

Choose Between a Fixed Height and AutoFit

A fixed height is useful when a worksheet needs consistent row sizes, such as a printable form, a schedule, or a table with aligned entries. It also gives you control over the visible whitespace. If you set a row too short, however, wrapped text or a large font may not display fully.

AutoFit lets Excel choose a height based on the contents it can measure. Select the relevant rows, then choose Home > Cells > Format > AutoFit Row Height. You can also double-click the boundary below a row number to AutoFit that row. Excel may increase the height to show wrapped text on multiple lines, and it can reduce excess space when the contents are shorter.

AutoFit and a centimeter target serve different purposes. AutoFit aims to fit visible content; it does not promise a particular measurement. If you AutoFit first and then need a precise height, check the resulting point value in Row Height, convert it, and set the desired value manually.

There are cases where AutoFit does not give the expected result. Merged cells, for example, can prevent Excel from calculating the required height reliably. A practical workaround is to unmerge the cells if possible, or set the row height manually after checking the text and wrapping. Very long text may also require several rows or a wider column rather than one exceptionally tall row.

Why the Same Height Can Look Different

A point is a physical measurement, but its appearance on a monitor depends on display scaling, screen density, and Excel’s zoom setting. At a different zoom level, the row can look taller or shorter on screen even though its stored height in points has not changed. Zoom changes the worksheet’s on-screen presentation; it does not convert the row height to a different unit.

Font choice also affects how much text fits in a row. Two rows with the same point height can look different if one uses a larger font, bold text, or a font with different character proportions. A row height of 30 points does not mean that every font or wrapped paragraph will fit within it.

Printed output adds another consideration. Excel stores row height in points, but page scaling can change the size of worksheet content on paper. If a sheet is scaled to fit a page, the printed row may not have the same physical size it would at 100% scale. For a measurement-sensitive printout, review the print preview and scaling settings, then confirm the result on the actual printer and paper.

Common Row-Height Problems

  • The row looks too short: Check whether text wrapping is on and whether the row has a fixed height. Use AutoFit or increase the height manually.
  • Text is clipped after changing the font: A larger font can need more vertical space. Select the rows and use AutoFit, then review any rows with merged cells.
  • A number entered as centimeters seems wrong: Excel interprets the dialog entry as points. Convert the centimeter target before entering it.
  • Only some rows changed: The height applies only to the rows selected when you opened the dialog. Select all intended row headings before setting it.
  • A row seems to have disappeared: It may be hidden, or its height may have been set to zero. Select the rows above and below, right-click their headings, and choose Unhide if the row is hidden.
  • Rows vary after pasting data: Pasted formatting can bring row heights from another range or workbook. Select the affected rows and set one consistent height, or use AutoFit if the contents should determine it.

Excel on Mac and in a Browser

On Excel for Mac, row heights are also measured in points, so the conversion does not change. The ribbon’s Home tab includes row-formatting controls; depending on the window layout, use the row-heading context menu or the Format controls to open Row Height or AutoFit Row Height. Mac keyboard shortcuts can differ from Windows shortcuts, but no keyboard shortcut is required for the steps above.

Excel for the web also uses point values for row height. You can adjust rows from their headings, including by dragging a row boundary, and use the available row-height formatting command when you need a numeric value. If a particular control is not visible in the browser layout, opening the workbook in the desktop app provides the full ribbon controls. In all versions, centimeters are a conversion for your reference rather than the unit entered in the row-height box.

Frequently Asked Questions

What is the default Excel row height in centimeters?
A common default is 15 points, which converts to about 0.53 cm. The exact standard height can vary with workbook and default-font settings, so check a row in your own sheet if precision matters.

How many points is 1 cm in Excel?
One centimeter is approximately 28.35 points. Multiply centimeters by 72 and divide by 2.54 to convert a target measurement into the points Excel expects.

Can I enter row height directly in centimeters?
No. Excel’s row-height controls use points, not centimeters. Convert the measurement first, then enter the point value in the Row Height dialog.

Does changing worksheet zoom change row height?
No. Zoom changes how large the worksheet appears on screen, not the row’s stored height in points. Display scaling can also affect its apparent size on your monitor.

Why does AutoFit not make a row the height I expect?
AutoFit estimates the space needed for cell contents; it does not target a centimeter value. Merged cells and text wrapping can complicate the calculation. Set a fixed point value if you need a specific height.

What is the maximum Excel row height in centimeters?
The maximum is 409 points, or approximately 14.43 cm. That is a maximum, not a recommended size; use a smaller height when it displays the contents clearly.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.