Excel’s maximum row height is 409 points. In Microsoft Excel for Microsoft 365 on Windows, you can set a row to that limit, but Excel cannot make it taller; if its contents need more room, you will need to change the layout or presentation.
What Excel’s maximum row height 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 in physical measurement. The number of pixels it occupies on screen varies with display scaling, screen resolution, and zoom, so a pixel estimate is not a reliable way to set an exact height.
Excel’s published worksheet limits list the maximum row height as 409 points. A typical new workbook has a default row height of about 15 points, though the default can vary with the workbook’s font and settings. The maximum is a firm cell-layout limit, not a recommendation for ordinary rows. Even a row set to 409 points may not be enough for an unusually long block of wrapped text.
Height applies to the entire row across the worksheet. You cannot make one cell in a row taller than its neighbors while keeping the same row number. If just one cell needs more space, increasing the row height also increases the height of every other cell in that row.
How row height works
A row’s displayed height is influenced by its assigned height and the content and formatting of its cells. A short line in a small font may fit comfortably in a low row. Wrapped text in a larger font, multiple lines, or generous paragraph spacing may need considerably more room. The visible result also depends on whether Wrap Text is enabled and whether the cell is merged with other cells.
When a row has a fixed height, Excel does not keep enlarging it as you add content. Text that does not fit may be hidden from view in the cell, even though it remains in the worksheet. You can still select the cell and inspect its full contents in the formula bar. If Wrap Text is off, text may sometimes appear to continue into empty cells to the right; that display can stop when a neighboring cell contains data.
Do not confuse row height with the number of worksheet rows. Modern Excel worksheets can contain up to 1,048,576 rows, but each individual row remains subject to the 409-point height limit. Increasing a row does not add worksheet capacity; it only changes how much vertical space that row uses.
How to set a specific row height
In Excel for Microsoft 365 on Windows, use the ribbon to enter a height directly:
- Select the row or rows using their numbered row headers. Drag across the row numbers to select a consecutive group.
- Open Home > Format > Row Height.
- Type a value up to 409 in the Row Height box, then select OK.
If several rows are selected, the value is applied to all of them. This is useful for making a group of headings or data rows consistent. To select the entire worksheet, use the Select All button at the top-left corner where the row and column headings meet, then apply the height; be aware that changing every row can make the sheet difficult to navigate and print.
You can also drag the boundary below a row number to change its height visually. Dragging is convenient for a quick adjustment, but it is less precise than entering a value. To resize several selected rows together, drag the boundary of one of the selected row headers. On a Mac, select the rows and use the Format menu’s row-height command, or use the row-header boundary. In Excel for the web, dragging the row boundary is a straightforward option; available ribbon commands can differ slightly from the desktop app.
AutoFit: letting Excel size a row to its contents
If the goal is to show wrapped content rather than use a particular measurement, try AutoFit Row Height. Select the relevant rows, then choose Home > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click it. Excel adjusts the row based on the content it can measure in that row.
AutoFit works best when the cells have ordinary, unmerged layouts and the appropriate text formatting is already in place. For paragraphs, first select the cells and turn on Home > Wrap Text, then apply AutoFit. Otherwise, a long entry may remain on one line or appear to spill across empty neighboring cells instead of gaining the height you expected.
Merged cells are a common exception. Excel may not AutoFit a row correctly when text is in a merged range, because the merged layout makes it difficult to calculate the required height. If AutoFit leaves the text clipped, set a suitable height manually, unmerge the cells and use Center Across Selection where appropriate, or reorganize the layout. AutoFit also cannot exceed the maximum height: if the calculated height would be greater than 409 points, the row cannot display all the text at once.
What happens when content needs more than 409 points
Excel will not create an unlimited-height row. At the maximum, some content may remain out of sight in the grid. That does not mean the text has been deleted. Select the cell to read its complete entry in the formula bar, or edit the cell to review the text directly. Before changing the layout, check that you are dealing with a display issue rather than a cell containing only part of the intended text.
A very tall row can also be awkward to work with. It takes up a large part of the screen, can make scrolling through neighboring records cumbersome, and may split across pages when printed. A long note or description often works better when stored in a separate notes column, divided into several rows, or displayed outside the grid in a text box or comment, depending on how readers need to use it.
For printed output, check the worksheet in File > Print before assuming a tall row will appear as one uninterrupted block. Page breaks and scaling affect the printed result, and a row may be divided between pages. Adjust page layout or print scaling if the goal is to keep a particular record together, while checking that the resulting text remains readable.
Common reasons a row will not look right
When text appears cut off or a height change seems ineffective, check these likely causes before rebuilding the sheet:
- Wrap Text is off. Turn it on for the selected cell or cells if the entry should occupy multiple lines within the column.
- The row is already at its limit. A height above 409 points is not available, so use a different layout for content that needs more space.
- The cells are merged. Merged ranges can interfere with AutoFit. Try a manual height or a non-merged layout.
- The row is hidden. A row height of zero hides the row. Select the row headers on either side, right-click, and choose Unhide, or use the row visibility options under Home > Format.
- The column is too narrow. Wrapped text needs additional lines when the column is narrow. Widening the column may reduce the required row height.
- Formatting is driving the size. A larger font or multiple lines can require a taller row. Check the cell’s font and alignment settings as well as its text.
A useful diagnostic is to select the cell and look at the formula bar. If the full content is present there, the problem is usually how the grid displays it. If only part of the intended entry is present, the issue is with the cell’s content rather than its row height.
Choosing a practical alternative to maximum height
Use the smallest height that makes the sheet easy to read and work with. A 409-point row is appropriate only when a single row genuinely needs a great deal of vertical space. In a table of records, consistent, moderate heights are easier to scan and filter. Consider these alternatives when a cell would need to approach the limit:
- Widen the column. A wider column reduces line wrapping and can make a long description fit in fewer lines.
- Split the content. Put separate details on separate rows, or move long notes into a dedicated column or worksheet.
- Use a text box. A text box can present explanatory text without forcing the data row to become extremely tall.
- Review the formatting. Remove unnecessary blank lines or reduce oversized font settings if doing so preserves readability.
- Change the presentation. For a report, a separate page or document may be more suitable than putting a long narrative into one spreadsheet cell.
For example, a short product name and price usually belong in a compact row, while a multi-paragraph product description may be easier to maintain in a separate description field or a dedicated detail sheet. Making every row enormous just to accommodate one unusually long entry can make the rest of the data harder to use.
Frequently Asked Questions
What is the maximum row height in Excel?
Excel’s maximum row height is 409 points. The limit applies to each row, regardless of how many worksheet rows the workbook contains.
Can I set an Excel row higher than 409 points?
No. Excel does not support a row height above 409 points. If the content does not fit, use a wider column, split the content, or move it to another layout.
Why does AutoFit not expand my row?
Check whether Wrap Text is enabled and whether the cell is merged. AutoFit may not measure merged-cell content as expected, and it cannot expand a row beyond the 409-point maximum.
Does increasing row height change the font size?
No. Row height changes the space available in the row, not the font size. Change the font separately if you want the text itself to appear larger or smaller.
Can a row be taller in Excel for Mac or Excel for the web?
The 409-point worksheet limit is not a Windows-only setting. The interface for changing height may differ by platform; selecting rows and adjusting their row-header boundary is a practical visual method.
Related
- Excel Column Length: Rows, Width, and Limits
- Excel Middle Value Extraction: Find the Median
- Excel Middle Years Academy: What Families Should Know
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Clear the Outlook GAL CacheTo refresh the Global Address List (GAL) cache in classic Outlook for Microsoft 365 on Windows, select Send/Receive…
- Excel Cell Auto Adjust: How to Fit Width and Row HeightTo auto-adjust cells in Excel for Microsoft 365 on Windows, select the column or row, then double-click the…
- Excel Column Merge: Combine Cells or Join Text in Excel?In Excel, “merge columns” can mean either joining cells visually or combining the text they contain. To make…
- Google Wedding Budget Spreadsheet: Setup and TrackingA Google wedding budget spreadsheet is a Google Sheets file for listing estimated costs, vendor quotes, final prices,…
- Adding a Header in Word: Steps and OptionsTo add a header in Microsoft Word for Microsoft 365 on Windows, choose Insert > Header, select a…
- Outlook Excel Sheet: Create a Data Entry Form in ExcelYes. In Excel for Microsoft 365 on Windows, prepare a worksheet as a list, add Excel’s built-in Form…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.