Excel Row Height Limit: The 409-Point Maximum

The maximum row height in Excel for Microsoft 365 on Windows is 409 points. To set a row’s height, select it and choose Home > Cells > Format > Row Height; enter a value up to 409.

What the 409-point limit means

Row height is measured in points, a typographic unit: 72 points equal one inch. A 409-point row is therefore about 5.68 inches tall before any printing or display scaling is applied. The limit applies to an individual worksheet row; it is not a limit on how many rows a worksheet can contain.

Excel can hold a large amount of text in a cell, but that does not mean the cell can make its row grow without limit. A row’s height determines the space available to display its contents. At the maximum, additional wrapped lines may not be visible in the grid. The cell’s content remains in the worksheet unless it is edited or deleted; the issue is how much of it can be seen in the cell.

Height is separate from column width. Excel measures row height in points, while column width is based on character measurements and the workbook’s default font. Changing zoom affects how large the worksheet appears on screen, but it does not increase the row-height maximum or change the height value stored for the row.

How to set a row to its maximum height

In desktop Excel for Windows, select a row or several rows using the row-number headings at the left of the sheet. Then choose Home > Cells > Format > Row Height, type 409, and confirm. The same command is available by right-clicking a selected row heading and choosing Row Height. If the selection contains multiple rows, the entered height is applied to each selected row.

You can also drag the boundary below a row heading to change its height. Dragging is convenient for rough adjustments, but the dialog is more useful when you need a particular value or want several rows to match. The Windows keyboard sequence Alt+H, O, H opens the Row Height command; press the keys in sequence rather than all at once.

To select one row, click its number at the left edge of the worksheet.
To select adjacent rows, drag across their row headings or select the first, then hold Shift and select the last.
To select nonadjacent rows, hold Ctrl while clicking their headings.
To select the entire worksheet, use the Select All corner above row 1 and to the left of column A, then set the height. This changes every row in the sheet, so use it only when that is intended.

In Excel for Mac, select the row headings and use the row-height command in the Format menu, or open the row-heading context menu. Ribbon and menu layouts can differ by release. Excel for the web also supports changing row height from the row heading; its available controls may differ from the Windows desktop ribbon, so dragging the boundary is a straightforward alternative.

AutoFit and wrapped text

AutoFit asks Excel to set row height to suit the visible cell contents, rather than assigning the maximum to every row. On Windows, select the rows and choose Home > Cells > Format > AutoFit Row Height. You can also double-click the lower boundary of a selected row heading. This is usually the best first step when text is cut off after you enable wrapping or change a column width.

For a cell’s text to use multiple lines within its column, select the cell and choose Home > Alignment > Wrap Text. Excel can then increase the row height to show the wrapped lines, subject to the row-height limit. A narrower column generally creates more lines and needs more height; a wider column may let the same text fit on fewer lines. AutoFit is based on the current contents, column widths, font, and formatting, so changing any of those can change the appropriate height.

AutoFit is not the same as setting a fixed height. If a row has a manually assigned height, it may not expand to show new or edited text automatically. Run AutoFit again after changing the content or width. Also check whether the row is already at 409 points: AutoFit cannot exceed the maximum, even if the cell contains more lines than will fit.

Why text may still be hidden

If a cell seems to contain more text than its row can display, first distinguish between hidden text and missing text. Click the cell and inspect the formula bar to see its full value. You can also edit the cell or copy its contents elsewhere to check what is stored. A cell’s visible area is not a reliable measure of how much text it contains.

Check these common causes before assuming the workbook is damaged:

Wrap Text is off: Long text may run into empty cells to the right or appear cut off when neighboring cells contain values. Turning on Wrap Text and using AutoFit can help.
The row is set to a fixed height: Use AutoFit Row Height, or enter a larger value, to show more content.
The row is already at the maximum: A value that needs more than 409 points cannot be displayed in one cell’s row. Consider splitting the content or changing the layout.
The cell is merged: AutoFit often does not calculate the needed height correctly for merged cells. More on this limitation appears below.
The row is hidden: A hidden row has no visible height. Select the surrounding row headings, right-click, and choose Unhide.

Large fonts, line breaks entered within a cell, and narrow columns can all increase the height required. If only part of a sentence is visible, check the column width and wrapping as well as the row height; making the row taller is not always the most effective fix.

Merged cells and other layout limitations

Merged cells are a frequent reason AutoFit appears not to work. When cells across columns are merged, Excel may not automatically determine how tall the row must be to show all wrapped text. The maximum is still 409 points, but even below that limit the row may not resize to the expected height. You may need to adjust it manually using Row Height or drag the row boundary, checking the result after each change.

For worksheets where reliable resizing matters, avoid merging cells that contain long text. A layout using Center Across Selection, where suitable, or placing a heading in one cell can be easier to maintain. Merging is often used for titles, but merged ranges can also complicate sorting, filtering, selection, and copying. If the merged appearance is essential, keep the text short or allow room for manual row-height adjustments.

Text boxes are another option for explanatory notes that need more vertical space than a cell can provide. They can be positioned over the grid and resized independently, although they do not behave like ordinary cell contents when sorting or filtering. For data that needs to be searched, calculated, or exported, splitting a long passage into multiple rows is usually more useful than putting it in a floating shape.

Screen height versus printed height

The 409-point limit describes the row’s worksheet height, not a guaranteed printed size. Page setup options can scale a worksheet when printing, making its contents smaller or larger on paper relative to the page. Changing print scaling does not let a row exceed the worksheet limit; it changes how the sheet is fitted to the printed page.

A tall row can also take up much of a printed page, or force nearby content onto another page depending on the page breaks and scaling settings. If the problem is how the sheet prints, check Print Preview and page layout settings instead of repeatedly increasing the row height. For a compact report, reducing unnecessary line breaks, widening columns, or placing detailed notes on a separate sheet may produce a clearer result than using a near-maximum row.

Choosing a practical row height

The maximum is a boundary, not a recommended default. A very tall row can make a worksheet difficult to scan because it pushes other records far apart. For ordinary tables, use AutoFit or a consistent modest height and reserve very tall rows for content that genuinely needs the space. If a row is close to 409 points, consider whether the information belongs in a separate field, row, worksheet, or document.

For example, if a feedback entry wraps into more lines than fit in a row, one option is to widen the comments column and run AutoFit again. If the text still needs more height, divide the entry into a main record and a related detail row, or keep a short summary in the table with the full note in a separate location. This keeps the worksheet readable while preserving the complete information.

When applying a height to a large selection, consider whether every row should really be the same size. Selecting the entire sheet and assigning 409 points can make routine navigation cumbersome and create unwieldy printouts. Use the maximum only for specific rows, and use AutoFit or a smaller fixed height for the rest.

Frequently Asked Questions

Can an Excel row be taller than 409 points?
No. Excel’s maximum row height is 409 points. To show more content, change the layout, split the material across rows, or use another place for the full text.

Why does AutoFit stop before all my text is visible?
AutoFit cannot go beyond 409 points, and it may not size merged cells as expected. Check the row’s current height, confirm Wrap Text is enabled, and consider widening the column or reorganizing the content.

How many inches is 409 points?
Because 72 points equal one inch, 409 points is about 5.68 inches. That describes the worksheet row measurement; printed output can appear at a different size if print scaling is applied.

Does changing zoom let me fit more text in a row?
No. Zoom changes the on-screen scale of the worksheet, not the row’s stored height or its 409-point maximum. Adjust the row, column width, wrapping, or layout to change what is visible.

Can I show a long cell without making the row extremely tall?
Often. Widen the column, remove unnecessary manual line breaks, or move detailed text to another row or a separate location. A text box can work for explanatory material, but it is less suitable than cell data for sorting and filtering.

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.