Excel Max Cell Height: The 409-Point Row Height Limit

In Excel for Microsoft 365 on Windows, the maximum row height is 409 points, or about 5.68 inches (14.4 cm). A cell does not have its own separate height: its height is controlled by the worksheet row, so the limit applies to every cell in that row.

What the 409-point limit means

Excel’s published worksheet specifications give 409 points as the maximum row height. A point is a typographic unit equal to 1/72 of an inch, so 409 points is roughly 5.68 inches. This is a limit on the row itself, not a target size or a guarantee that all content will be readable at that height. If a cell contains more wrapped text than can fit inside the maximum-height row, Excel cannot make the row any taller to show it all.

People often ask for the maximum cell height because a long description, address, or pasted block of text seems to disappear. The key distinction is that the cell holds the content while the row sets the available vertical space. You can enlarge the row, change the text layout, or distribute the content across rows, but you cannot give one cell in a row extra height without changing the row for its neighbors too.

At the default worksheet zoom, the row may not look exactly 5.68 inches tall on your monitor. Zoom, display scaling, font rendering, and the physical size of the screen affect how it appears. The stored height is measured in points; the on-screen pixel count is a display representation, not a different height limit.

Why Excel measures row height in points

Points are a familiar unit for typography, which makes them useful for sizing rows around text. A normal row is often 15 points high, though the default can vary with the workbook’s default font and other settings. A 409-point row is therefore much taller than a typical worksheet row, but it is still a fixed boundary in Excel’s grid.

Row height is also shared across the entire row. For example, if row 12 contains a short number in column A and a long wrapped note in column B, making row 12 taller affects both cells. Excel does not let you set column B’s cell to 100 points high while leaving A12 at 15 points. To create different vertical areas, use separate rows or a different layout.

How to set a row to the maximum height

To enter a specific height in Excel for Microsoft 365 on Windows, select the row or rows using their number labels, then choose Home > Format > Row Height. Enter 409 and select OK. If you select several rows first, the same height is applied to all of them.

Click the row number at the left edge of the worksheet. Drag across row numbers to select multiple rows.
On the ribbon, choose Home > Format > Row Height.
Enter 409, then choose OK.

You can also drag the lower boundary of a row heading to change its height by eye. That approach is convenient for a quick adjustment, but it is less precise than entering a value. Double-clicking the boundary between row headings runs AutoFit instead; it sizes the row for its contents rather than setting it to the maximum.

On Excel for Mac, use the row headings to select the row, then use Format > Row > Height from the menu bar to enter a value. In Excel for the web, select the row and use the row-formatting controls to set its height; the exact location can differ slightly as the web interface changes. The underlying row-height limit is not a way to make an individual cell taller on any of these platforms.

How AutoFit works with wrapped text

AutoFit is usually the right first step when text is cut off because the row is simply too short. Select the relevant rows and choose Home > Format > AutoFit Row Height. For a single row, you can also double-click the boundary below its row number. If the cell needs multiple lines, turn on Home > Wrap Text so Excel can display the text on successive lines, then AutoFit the row.

AutoFit estimates the height needed for the visible cell contents and formatting. The result depends on column width: a narrow column creates more wrapped lines than a wide one. Changing a column’s width can therefore change the number of lines and the row height needed. Font size, bold or other font formatting, and manual line breaks can affect the result too.

AutoFit is not unlimited. If the required height reaches Excel’s maximum, the row cannot keep expanding, even if the cell contains additional lines. Also, if someone manually sets a row height and later edits the text, the row may not resize automatically. Run AutoFit again after changes if you want Excel to recalculate the height.

What happens when text exceeds the available height

When a row is too short for wrapped text, some lines may not be visible until you increase the row height. At the 409-point limit, further increases are impossible, so content that needs more space can remain clipped from view. The text is not necessarily deleted; selecting the cell and reading the formula bar can help confirm that the full entry is still present.

Unwrapped text behaves differently in the horizontal direction. If adjacent cells are empty, text may visually spill across them. That does not mean the cell has expanded, and neighboring content can block the spill. Turning on Wrap Text moves the display into the cell’s row, where the height limit applies. For a long paragraph, a wider column may reduce line count, but it cannot make a row exceed the maximum.

Before deciding the limit is the problem, check whether the row is hidden or whether a filter, outline, or grouping has collapsed it. A hidden row has no visible height, which is different from a very tall row. Also confirm that the text is actually in the cell you expect and that the column is wide enough to display it usefully.

Merged cells and other layout complications

Merged cells can make row sizing less predictable. A merged area may span multiple columns, but Excel’s AutoFit Row Height does not reliably calculate the required height for merged-cell text. If a merged heading is clipped, set the relevant row height manually and check the result. A more dependable alternative is often to unmerge the cells, use Wrap Text, and adjust the column layout.

For a heading that should appear centered across columns without combining cells, consider the Center Across Selection alignment option in the Format Cells dialog. Unlike merging, this keeps the cells separate, which avoids some selection, sorting, and AutoFit inconveniences. It is not suitable for every design, but it can be a practical alternative for worksheet titles.

Multiple rows can also be used to divide a large note into manageable sections. This is useful when a single entry would exceed the maximum, or when different parts need separate labels, formatting, or filtering. If the content must remain one logical value, consider keeping the full text in one cell and using a larger column, a separate detail sheet, or a comment or note for supplementary information.

Screen appearance versus printed size

A row that appears small or large on screen is not necessarily set incorrectly. The worksheet zoom changes how many screen pixels represent a point, while Windows display scaling changes the size of interface elements. Use the Row Height command to inspect or set the numerical value rather than estimating from the screen.

Printing introduces another distinction. Page setup scaling, such as fitting a sheet to a page, can shrink the printed worksheet, but it does not raise the row-height limit in the workbook. If the printed text is too small, review print scaling and page orientation rather than trying to make one row taller than Excel allows. Use Print Preview to check whether the row fits on the page and whether the content remains legible.

Practical alternatives when 409 points is not enough

If a maximum-height row still cannot show everything clearly, changing the structure is usually better than repeatedly adjusting its height. Choose an option based on whether the content needs to be visible at once, remain in one cell, or fit on a printed page.

Widen the column: More width can reduce wrapped lines and make a long paragraph fit in a shorter row. Check that the added width does not make the worksheet hard to navigate.
Use a smaller font: Reducing font size can fit more lines into the available space, though it may harm readability, especially in printed copies.
Split the content: Put separate sentences, sections, or items in multiple rows so each part has room and can be reviewed independently.
Use a separate detail area: Keep a short summary in the main table and store long descriptions on another sheet or in an appropriate note or comment.
Review manual line breaks: Extra line breaks can create more lines than expected. Remove unnecessary breaks or adjust the text and column width.

Choose based on the purpose of the worksheet. A very tall row may technically hold more visible text, but it can make sorting through records and comparing rows awkward. For tables used as lists or databases, a concise summary plus a separate place for full details is often easier to work with.

Frequently Asked Questions

What is the maximum height of an Excel cell?

The maximum is 409 points for the row containing the cell, which is about 5.68 inches. Excel does not provide a separate height setting for one cell within a row.

Why will Excel not let me make a row taller?

You have likely reached the 409-point row-height limit. Excel cannot extend the row beyond that maximum. Widen the column, reduce the font size, or move some content to another row or location.

Does Wrap Text automatically make a row as tall as needed?

Wrap Text displays content on multiple lines, and AutoFit Row Height can resize the row to show those lines. However, AutoFit cannot exceed the maximum row height, and merged cells may not AutoFit correctly.

Can I make just one cell in a row taller?

No. Row height is shared by every cell in the row. Use additional rows or a different layout if one item needs more vertical space than the others.

Is 409 points the same as 409 pixels?

No. Points and pixels are different units. Excel measures row height in points; the number of pixels used to draw that height depends on display scaling and zoom.

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.