Excel Row Height in mm: Convert Points to Millimetres

How-to basics · Updated November 18, 2026

Excel measures row height in points, not millimetres. To convert a value, multiply points by 25.4 ÷ 72: for example, the common 15-point row height is about 5.29 mm. To set a row to a particular millimetre measurement, convert millimetres to points by multiplying by 72 ÷ 25.4, then enter that point value in Excel.

What Excel means by row height

A row’s height is the vertical space assigned to its cells. In desktop Excel for Microsoft 365 on Windows, the Row Height dialog reports and accepts this measurement in points. A point is a typographic unit equal to one seventy-second of an inch. Because an inch is exactly 25.4 mm, one point is approximately 0.35278 mm.

That unit describes the row’s layout in the workbook; it is not a guarantee that the row will occupy precisely the same number of millimetres on every screen or printed page. Display scaling, zoom, printer settings, and page scaling can all affect how large the row appears outside the dialog. The point value is the useful reference when editing the worksheet itself.

Many new workbooks using Excel’s familiar default font settings start with rows at 15 points, or roughly 5.29 mm. This is a common starting value, not a universal measurement for every workbook. A different default font, workbook template, or existing formatting can produce a different standard row height.

Convert points to millimetres

Use this conversion:

  • Points to millimetres: points × 25.4 ÷ 72.
  • Millimetres to points: millimetres × 72 ÷ 25.4.

For instance, 20 points × 25.4 ÷ 72 equals approximately 7.06 mm. In the reverse direction, a target of 8 mm works out to 8 × 72 ÷ 25.4, or approximately 22.68 points. Enter 22.68 in Excel’s Row Height box to get close to that worksheet measurement.

The conversion is straightforward, but the result may need rounding to a practical number of decimal places. Two decimal places are usually enough for a manually entered value. If you need a precise physical size on paper, print a test page at the intended scale: the workbook’s point setting alone does not control every part of the print process.

Set a row height in Excel for Windows

To enter a row height, select the row or rows, open the Row Height command, and type the converted value in points. The dialog is the place to enter a number; it does not accept millimetres as its unit.

  1. Select a row by clicking its number at the left of the worksheet. Drag across several row numbers or hold Ctrl while selecting individual row headings to adjust more than one row.
  2. On the ribbon, choose Home > Cells > Format > Row Height.
  3. Enter the height in points, such as 22.68 for a target near 8 mm, and select OK.

You can also right-click a selected row heading and choose Row Height. On Windows, the keyboard sequence Alt, H, O, H opens the Row Height command; press the keys in sequence rather than simultaneously. The neighboring AutoFit command has a different sequence, Alt, H, O, A.

To apply one value across the entire worksheet, use the select-all button at the corner where the row and column headings meet, then open Row Height and enter the value. This changes every row, so it can remove useful differences such as taller title rows. If only a particular section needs consistent sizing, select just those rows instead.

Set a target size on Mac or Excel for the web

The measurement remains points in Excel for Mac as well. Select the relevant row headings and use the row-height command available from the Home ribbon’s Format menu, or use the row-heading context menu if that is more convenient. Ribbon layouts can vary by Mac release, so look for Row Height under the formatting options rather than expecting to enter a millimetre value directly. Windows Alt-key sequences do not apply to Mac; use the menu or context menu.

Excel for the web also provides row-height controls, though the ribbon and context-menu layout may differ from the Windows desktop application. Select the rows and look for the row-height option in the formatting controls. If the web interface does not expose the setting where you expect, open the workbook in the desktop app. In all cases, convert your desired millimetres to points before entering the value.

Useful conversion examples

These approximate equivalents help when matching a document specification or estimating how a row will look. The millimetre figures are rounded to two decimal places.

  • 12 pt is about 4.23 mm.
  • 15 pt is about 5.29 mm.
  • 18 pt is about 6.35 mm.
  • 24 pt is about 8.47 mm.
  • 30 pt is about 10.58 mm.

For the reverse conversion, a 5 mm target is about 14.17 points, 10 mm is about 28.35 points, and 20 mm is about 56.69 points. These are not preset Excel sizes; they are the point values calculated from the requested metric dimensions. A row containing wrapped text may need to be taller than the converted target to show all its contents.

Why the printed size may look different

A row set to a particular point value has a defined layout height inside the worksheet, but a printed page can be scaled to fit a selected paper size or page count. For example, if a sheet is set to fit all columns on one printed page, Excel may scale the worksheet content down. The row will then appear smaller on paper than its unscaled point conversion suggests.

Printer drivers and physical margins also affect the available page area. For print-sensitive work, check Page Layout > Scale to Fit and the settings in the Print view before judging physical dimensions. A scale of 100% is more suitable when preserving dimensions matters, provided the worksheet fits the paper. If Excel must shrink the sheet to fit, check a printed sample with a ruler rather than assuming that 10 mm in the row-height conversion will measure exactly 10 mm on the page.

On screen, zoom changes how much of the worksheet fits in the window and changes its apparent size. Windows display scaling and monitor pixel density affect the physical size of screen elements too. These viewing differences do not mean that Excel has changed the point value stored for the row.

Row height, AutoFit, and wrapped text

A manually entered height fixes the row at the chosen value. If the cell contains more text than fits vertically, some of it may be hidden until the row is enlarged, the text is edited, or wrapping is changed. This is especially common after setting a short height for cells with long labels or multiple lines.

AutoFit tells Excel to size a row according to its contents. Select the row or rows and choose Home > Cells > Format > AutoFit Row Height, or double-click the lower boundary of a selected row heading. For wrapped text, make sure Home > Alignment > Wrap Text is enabled; otherwise, AutoFit may not produce the multi-line layout you expect. Merged cells can also complicate automatic sizing, so a manual height may be necessary when text spans merged cells.

AutoFit is useful for revealing content, but it does not target a particular number of millimetres. If you run AutoFit after entering a precise height, Excel can change that height to suit the content. If you need both a fixed measurement and complete text visibility, adjust the text, font size, or column width and then check the row height again.

Row height is not the same as column width

It is easy to assume that both row height and column width use the same unit because they sit beside each other in the Format menu. They do not. Row height is measured in points, while column width is based on character-width units related to the workbook’s default font. A column-width value therefore cannot be converted to millimetres using the row-height formula.

This difference matters when designing a table to match a printed form. You can convert the required vertical measurement to points and set the row height directly, but horizontal sizing often requires print preview and a test print. Page scaling can alter both dimensions on paper, while the underlying column-width unit remains font-dependent.

Limits and common problems

Excel row height has an upper limit of 409.5 points, which is approximately 144.29 mm. If a requested value exceeds the limit, Excel cannot make the row that tall. In ordinary worksheets this ceiling is unlikely to matter, but it can affect attempts to create a very large blank area or display unusually extensive cell content in one row.

If a value appears not to stick or the displayed result seems unexpected, check these common causes:

  • Wrong unit: the Row Height box expects points. Entering 8 when you mean 8 mm produces an 8-point row, only about 2.82 mm.
  • AutoFit changed the size: running AutoFit after setting a manual height can replace the value.
  • Text is clipped: the chosen height may be too small for wrapped text or a large font.
  • Only some rows were selected: verify the row headings before applying a shared value.
  • Print scaling changed the apparent size: inspect page scaling and verify with a printed sample.

A hidden row is a separate issue from a short row. If a row seems to have no height, check whether it has been hidden, including through a filter, rather than assuming its height is zero. Select the surrounding row headings and use the unhide command if necessary. Also check whether the worksheet is protected, since protection settings can restrict formatting changes.

Frequently Asked Questions

How many millimetres is 15-point row height in Excel?
Fifteen points equals about 5.29 mm, using 15 × 25.4 ÷ 72. It is a common default row height, but the actual default can vary with workbook settings and fonts.

Can I type millimetres directly into Excel’s Row Height box?
No. Excel’s row-height setting is in points. Convert the millimetre target to points by multiplying by 72 ÷ 25.4, then enter the result.

What point value should I use for an 8 mm row?
Eight millimetres is about 22.68 points. Enter 22.68 in the Row Height dialog to set a row close to that worksheet height.

Why does my row look different on the printed page?
Print scaling, paper size, margins, and printer settings can change the physical size of worksheet content. Check the print scaling settings and measure a test print if the paper dimensions are important.

Does changing zoom change row height in millimetres?
No. Zoom changes the on-screen appearance, not the point value assigned to the row. Display scaling and monitor characteristics can affect its apparent physical size on screen.

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.