Excel Cell Height Limit: Maximum Row Height Explained

In Excel for Microsoft 365 on Windows, the maximum row height—and therefore the height of every cell in that row—is 409 points, or about 5.68 inches. A cell does not have an independent height setting: changing one cell’s height changes the whole row.

The maximum height and what it means

Excel measures row height in points, a typographic unit equal to 1/72 of an inch. At the 409-point maximum, a row is roughly 5.68 inches tall as a physical measurement. The number of pixels it occupies on your monitor depends on display scaling and zoom, so the on-screen appearance may not match that inch measurement exactly.

The limit applies to a worksheet row, not to the amount of text or data a cell can contain. If content needs more vertical space than one row can provide, Excel does not create a taller cell beyond the limit. Instead, you may need to distribute the content across rows, change how it is displayed, or put it somewhere better suited to long text.

Excel’s row-height limit is easy to confuse with its column-width limit. Column width is measured using character-based units, while row height is measured in points. These are different settings with different limits; changing a column’s width does not raise the maximum row height.

Why a cell cannot have its own height

A worksheet is arranged as a grid. Each row has one height shared by every cell across that row, just as each column has one width shared by every cell down that column. For example, if you make cell B4 taller to show a wrapped paragraph, cells A4 and C4 become taller too. Excel cannot make B4 tall while keeping the other cells in row 4 short.

This shared layout matters when planning tables. A single long note in one row can create a very tall row that leaves neighboring cells with extra blank space. Conversely, setting a short height to keep a table compact may hide part of a wrapped entry elsewhere in the same row. If different records need very different amounts of text, consider putting detailed notes in a separate column or on a separate sheet rather than forcing the entire table to accommodate them.

How to set a row height manually

In Excel for Microsoft 365 on Windows, select the row or rows, then choose Home > Format > Row Height. Enter a value in points and select OK. To change several rows to the same height, select their row headers first; the setting applies to every selected row. You can select a continuous range by dragging across row numbers, or select separate rows with Ctrl-clicking their headers.

You can also drag the boundary below a row number to change that row’s height. Dragging is useful for visual adjustment, but it is less precise than entering a number. To give several rows the same exact height, select them and use the Row Height command. If you want to hide a row rather than make it small, use Home > Format > Hide & Unhide > Hide Rows; a hidden row has a height of zero and can be shown again with Unhide Rows.

Excel for Mac has a different interface layout, and the ribbon labels can vary by release; the row-header boundary can still be dragged, or use the row-height command in the Format menu. Excel for the web also lets you resize rows, though the available controls can differ from the desktop app. In each version, remember that the adjustment applies to the whole row.

Using AutoFit for wrapped text

AutoFit adjusts a row to accommodate its contents, up to Excel’s maximum. On Windows, select the relevant rows and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number to AutoFit that row. For text to occupy multiple lines within a cell, turn on Home > Wrap Text first. AutoFit can then increase the row height to show the wrapped lines.

For example, suppose a cell contains a sentence that wraps into four lines after you narrow its column. With Wrap Text on, AutoFit can make the row taller so those lines are visible. If the column is later widened, the sentence may fit on fewer lines, but the row may retain its previous height until you AutoFit it again. This is why a row can sometimes look unnecessarily tall after a layout change.

AutoFit is a sizing convenience, not a way around the 409-point ceiling. If the content needs more space than Excel allows, the row cannot expand further. In that case, shorten or reorganize the displayed text, use multiple rows, or choose another way to present the full content.

Merged cells and other AutoFit complications

AutoFit is unreliable with merged cells. When cells are merged vertically or horizontally, Excel may not calculate the required height in the way users expect, and AutoFit may leave some wrapped text hidden. This is a common reason a row appears too short even after choosing AutoFit Row Height.

If a merged cell contains important text, set the row height manually and check that the full text is visible. You may need to adjust the column width or the text itself as well. For worksheet designs that need automatic resizing, avoiding merged cells is often simpler. Center Across Selection can provide a similar visual effect for some layouts without merging cells, though it is not a replacement for every use of merged cells.

Other settings can affect what fits. A narrow column creates more wrapped lines; a larger font needs more vertical space; and indentation or added line breaks can change how text is laid out. A fixed row height can clip the visible display of wrapped text, but it does not delete the underlying cell value. Select the cell to inspect its contents in the formula bar, or increase the row height to reveal more.

Screen display, printing, and zoom are different

Worksheet zoom changes how large cells look on screen; it does not change their actual point height. Likewise, changing the monitor’s display scaling can alter the number of pixels used to draw a row without changing the row-height value. If a row looks different on another computer, check its numeric height rather than judging only by screen appearance.

Printing introduces another distinction. Page scaling can shrink or enlarge worksheet content to fit a printed page, but it does not raise the worksheet’s 409-point row-height limit. For example, using the Scale to Fit controls on the Page Layout tab can reduce the printed size of a large worksheet to fit a page. That may make text smaller on paper, but it does not turn an over-limit row into a taller worksheet row.

When a printed page cuts off content, first check the row height and wrapping in the worksheet, then review print scaling and print preview. A row that is already at its maximum may still be scaled down for printing, while a row that is too short in the sheet may continue to show clipped text even if the page fits.

Practical options when 409 points is not enough

Choose a solution based on whether the goal is to view, store, or print the full content. Useful options include:

Split the material across rows. Put a long explanation on several consecutive rows so each row stays within the limit.
Move details to a separate notes area. Keep the main table concise and store full descriptions on another sheet, linked by an ID or record name.
Widen the column or reduce unnecessary formatting. A wider column, smaller font, or fewer forced line breaks may reduce the number of lines required.
Use a comment or note for supporting information. This can keep the visible table compact, although the user must open the comment or note to read its contents.
Use a text box for a presentation-style sheet. A text box can be sized separately from the grid, making it useful for labels or explanations, but it is not a substitute for structured, sortable table data.

Do not reduce the row height merely to make a sheet look tidy if doing so hides information readers need. If a compact view is important, consider showing a short summary in the table and keeping the complete text accessible elsewhere.

Common checks when a row looks wrong

If a row refuses to become taller or text seems missing, check the cause before changing the whole worksheet. Confirm that you selected the correct row, that it is not hidden, and that the requested height is not above 409 points. Then check whether cells are merged, Wrap Text is enabled, and the column is wide enough for the intended layout.

If the row is too tall, select it and enter a smaller value in Row Height, or run AutoFit after widening the column.
If wrapped text is clipped, increase the height or use AutoFit; with merged cells, set the height manually.
If the row is hidden, select the rows around it and use the Unhide Rows command.
If the display changes after editing, run AutoFit again because Excel may not have recalculated the row’s preferred height.

These checks separate a true size limit from a formatting or visibility issue. In particular, a cell showing only part of a sentence does not necessarily mean the rest of the value is gone.

Frequently Asked Questions

What is the maximum height of an Excel row?
Excel’s stated maximum row height is 409 points, approximately 5.68 inches. Because cell height is shared across a row, this is also the maximum height available to a cell in that row.

Can I make one cell taller than the other cells in its row?
No. Excel assigns one height to the entire row. To give the content more space without enlarging neighboring cells, move it to another row or use a separate text box or notes area.

Why does AutoFit not show all my text?
AutoFit can stop at the maximum row height, and merged cells can prevent it from calculating the needed height correctly. Check Wrap Text, the column width, and merged-cell formatting; set the height manually if necessary.

Does changing zoom increase the row-height limit?
No. Zoom changes the worksheet’s on-screen magnification, not the row’s height in points. The 409-point maximum remains the same.

Can I type a row height greater than 409 points?
No. Excel does not permit a worksheet row to exceed its maximum. Divide the content across rows or use another display method when more vertical space is required.

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.