Excel Row Height in Inches: Conversion and Settings

How-to basics · Updated November 18, 2026

Excel measures row height in points, not inches: divide the height in points by 72 to convert it to inches. For example, a 15-point row is about 0.208 inches high, while a 36-point row is 0.5 inches. The number describes the row’s nominal height; printing scale and display settings can change how large it appears physically.

Why Excel Uses Points for Row Height

A point is a typographic unit: 72 points equal one inch. Excel uses points for row height because the measurement works naturally with text, fonts, and page layout. The height of a row has to accommodate characters and their line spacing, so a font-related unit is more useful for spreadsheets than an inch measurement alone.

In a typical new workbook, the default row height is often 15 points, which converts to 15 ÷ 72, or approximately 0.2083 inches. That is a common starting value, not a guaranteed height for every workbook. The workbook’s default font and font size, formatting, and application settings can affect the displayed default. A row with larger text or wrapped content may need more space.

Row height is also different from column width. Excel expresses row height in points, but column width is based on character units related to the workbook’s standard font. That is why a column-width value cannot be converted to inches using the same simple points-to-inches calculation.

Quick Conversion Examples

To convert a row height from points to inches, use this relationship: inches = points ÷ 72. To go the other way, multiply the desired inch measurement by 72 to get the number to enter in Excel. Excel’s Row Height box accepts points, so a desired physical height of half an inch corresponds to 36 points.

  • 12 points ÷ 72 = about 0.167 inches.
  • 15 points ÷ 72 = about 0.208 inches.
  • 18 points ÷ 72 = 0.25 inches.
  • 24 points ÷ 72 = about 0.333 inches.
  • 36 points ÷ 72 = 0.5 inches.
  • 72 points ÷ 72 = 1 inch.

These conversions are useful when a form, label, or printed sheet specifies a measurement in inches. If a specification calls for a row 0.4 inches tall, multiply 0.4 by 72: the corresponding Excel setting is 28.8 points. Excel may display or apply fractional point values differently depending on the interface and workbook, so check the final printout when the physical dimension is important.

How to Set an Exact Row Height in Excel

In Excel for Microsoft 365 on Windows, select the row or rows, then choose Home > Format > Row Height in the Cells group. Enter the desired value in points and select OK. For example, enter 36 to set the selected row to a nominal half-inch height. You can select several row headers first to apply the same height to all of them.

  1. Click a row number to select one row, or drag across row numbers to select a range.
  2. For nonadjacent rows, hold Ctrl while selecting the row numbers.
  3. Choose Home > Format > Row Height.
  4. Type a value in points, then select OK.

You can also right-click a selected row number and choose Row Height. To select the entire worksheet, click the triangle at the top-left corner between the row numbers and column letters, then set a height. Be aware that applying a height to every row can make a large worksheet difficult to read or print, and it may override carefully adjusted row sizes.

On Excel for Mac, select the rows and use Format > Row > Height from the menu, then enter the point value. Menu wording and ribbon layout can differ slightly by release. Excel for the web also provides row-height controls through the Home tab’s formatting options, though the precise menu presentation can vary as the web interface changes. In all cases, the height value is entered in points rather than inches.

AutoFit and Adjusting Rows by Dragging

If the goal is to show all the contents rather than reach a particular physical measurement, AutoFit is usually more convenient than calculating a height. Select the relevant rows and choose Home > Format > AutoFit Row Height. Excel adjusts the height to fit the tallest visible content in each row, including wrapped text where applicable.

For a quick manual adjustment, place the pointer on the boundary below a row number and drag it up or down. Excel shows a height measurement while you drag. Double-clicking that boundary applies AutoFit to the row. To adjust multiple rows together, select them first and drag the boundary of one selected row; the selected rows receive a common height.

Windows also supports ribbon key tips for these commands: press Alt, then H, O, H for Row Height, or Alt, H, O, A for AutoFit Row Height. Press the keys in sequence rather than holding them all down simultaneously. Keyboard sequences can be affected by ribbon or localization differences. On Mac, use the menu path or ribbon controls if the Windows key-tip sequence is unavailable.

What the Measurement Means on Screen

A point-to-inch conversion describes a nominal typographic size, not a promise that a row will occupy exactly that many inches on every monitor. The number of screen pixels used to draw a point depends on display scaling, operating-system settings, Excel’s zoom level, and how the application renders the sheet. Zoom changes the on-screen appearance of the worksheet but does not change the row-height value stored in points.

For a rough screen comparison, at a conventional 96-pixels-per-inch scale, one point corresponds to about 1.333 pixels. A 15-point row would therefore be around 20 pixels high under that simplified assumption. Actual screen appearance can differ, particularly on high-resolution displays or with Windows display scaling. Use the points value for consistent workbook formatting; do not treat a screen ruler or visual estimate as a precise physical measurement.

Excel may display rulers in inches in Page Layout view, depending on regional and application settings, but that does not change the units used in the Row Height dialog. Page setup measurements, such as margins, can use inches while row-height controls continue to use points. The two settings describe different parts of the worksheet layout.

Printing, Scaling, and Physical Size

When you print, a row set to 36 points is nominally half an inch before print scaling. If the sheet is scaled to fit a page, the printed row can be smaller or larger than its unscaled nominal size. For instance, scaling the page to 80% would make a 36-point row correspond to roughly 0.4 inches on the printed page, assuming the scale is applied uniformly. Printer settings and paper handling can introduce further differences.

To inspect print layout, use File > Print and review the preview. Check the selected paper size, orientation, margins, and scaling options. Excel’s Page Layout tab includes scale-to-fit controls, and the print settings may include options such as fitting the sheet to a page. These options can shrink content to make it fit, so a row that looks correct in the worksheet may not retain its nominal size in the printout.

If a printed form must meet a specific physical dimension, set the row height in points, avoid unintended scaling, and print a test page at the intended paper size. Measure the result with a ruler. This is more dependable than relying only on the worksheet display, because print drivers, printer margins, scaling, and paper choices all affect the final page.

Choosing a Height for Text and Tables

For ordinary data, a modest height that keeps labels readable is generally more useful than converting every row to inches. The right value depends on font size, line wrapping, borders, and the amount of information in each cell. A row containing a short date may fit at the default height, while a wrapped description may need several lines of vertical space.

  • Use the default or AutoFit for routine tables whose contents change.
  • Set a consistent point value for headings or form rows that should align visually.
  • Use wrapped text when the full entry should remain in one cell; then apply AutoFit if the row should expand.
  • For a printed form with a specified dimension, convert inches to points and verify the print scale.

For example, if a printed form calls for a 0.5-inch writing area, set the row to 36 points as a starting point. If the sheet is printed at 90% scale, the nominal printed height becomes about 0.45 inches, not 0.5 inches. That distinction matters for physical forms, but usually does not matter for a worksheet viewed on screen.

Common Row-Height Problems

If AutoFit does not make a row tall enough, check whether the cells contain wrapped text, whether the row has a manually assigned height, and whether the content is in merged cells. AutoFit may not correctly determine the needed height for merged cells. A practical workaround is to adjust the row manually, or redesign the layout so the text is not in a merged range.

If text appears cut off, the row may be too short, the column may be too narrow, or the cell may have text wrapping turned off. Increasing row height does not always solve a column-width problem. Conversely, widening a column may place a longer entry on one line and reduce the row height needed. Check the Home tab’s Wrap Text control and try AutoFit Row Height after the relevant content and column widths are set.

A row that seems to disappear may have a height of zero, which hides it, or may be hidden using the row menu. Select the rows above and below it, right-click, and choose Unhide. You can also select surrounding rows and use Home > Format > Hide & Unhide > Unhide Rows. Hidden rows are not the same as rows set to a small visible height.

Excel’s maximum row height is 409 points, or about 5.68 inches before print scaling. If a cell contains more text than can fit, consider widening the column, wrapping text, splitting the content across rows, or using a smaller font rather than expecting a single row to grow without limit.

Frequently Asked Questions

How many inches is a 15-point Excel row?
A 15-point row is 15 ÷ 72 inches, or approximately 0.208 inches. It is a common default, but the default can vary by workbook and formatting.

Can I enter row height in inches in Excel?
No. The Row Height setting uses points. Convert inches to points by multiplying by 72; for example, 0.25 inches is 18 points.

Does changing worksheet zoom change row height?
No. Zoom changes how large the worksheet appears on screen, not the row-height value. Print scaling, however, can change the printed size.

Why is AutoFit not adjusting my row?
Check that Wrap Text is enabled when you expect text to occupy multiple lines. AutoFit can also fail to size rows correctly when the relevant cells are merged, so manual adjustment or a different layout may be needed.

How tall is the maximum Excel row?
The maximum is 409 points, which is approximately 5.68 inches before print scaling. The printed result may be smaller if the worksheet is scaled to fit a page.

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.