Excel Row Auto Height: How to Fit Text Automatically

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, select the row or rows, then choose Home > Format > AutoFit Row Height. For a quick adjustment, double-click the boundary below a row number; if text is meant to wrap, turn on Home > Wrap Text first so Excel can size the row to show the extra lines.

What AutoFit Row Height Does

AutoFit Row Height changes a row’s height to accommodate the content Excel can display in its cells. A row containing a short value may remain compact, while a row with several lines of wrapped text may become much taller. Excel bases the adjustment on the displayed content, including the font and formatting, rather than on a fixed number of characters.

The height applies to the entire row, not just the cell that contains the longest entry. If one cell needs three lines, every cell in that row shares the resulting row height. This is useful for notes, addresses, product descriptions, and other entries that vary in length. It also means one unusually long entry can make a whole table row look oversized.

AutoFit is a sizing command, not a setting that permanently keeps every row in the ideal state. You can apply it again after changing content, formatting, or column width. In some circumstances—especially with merged cells or manually sized rows—the automatic adjustment may not give the result you expect.

How to AutoFit One Row or Several Rows

To adjust a particular row, use either the ribbon or the row heading. The ribbon route is useful when you want a repeatable command; the boundary shortcut is convenient when you are already working beside the row numbers.

  1. Click a cell in the row you want to resize, or drag across the row numbers to select several rows.
  2. On the Home tab, select Format in the Cells group.
  3. Choose AutoFit Row Height.

You can also point to the line between two row numbers in the row-heading area. When the pointer changes to a vertical resize indicator, double-click the boundary below the row you want to fit. If multiple rows are selected, double-clicking a boundary in the selection adjusts the selected rows to fit their contents.

On Windows, the ribbon KeyTip sequence is Alt, H, O, A: press the keys in sequence rather than all at once. KeyTips can vary with interface or language settings, so use the visible Home > Format menu if that sequence does not work in your setup.

Wrap Text Before Fitting Long Entries

AutoFit cannot make a cell display multiple lines merely by increasing the row height if the text is not wrapping. For a long description that should remain within a column, select the relevant cells and choose Home > Wrap Text. Then apply AutoFit Row Height. Excel can increase the row to show the wrapped lines while keeping the column width unchanged.

For example, imagine a worksheet with a narrow Notes column. A sentence may appear to run across empty cells, or it may seem cut off when the cell to its right contains data. Turning on Wrap Text makes the sentence flow onto additional lines within the Notes cell. AutoFit then gives the row enough height to display those lines, subject to Excel’s row-height limit.

Column width affects the result: a wider column usually needs fewer wrapped lines and therefore less height. If a fitted row is unexpectedly tall, check whether the column is too narrow, whether the cell contains manual line breaks, and whether the text includes extra spaces or paragraphs. You can add a deliberate line break while editing a cell with Alt+Enter on Windows; on Mac, use Control+Option+Return in many current Excel versions. The exact Mac key combination can depend on the keyboard and version.

Apply AutoFit to Every Row in a Worksheet

To fit all rows, select the whole worksheet first. Click the Select All button at the upper-left corner of the grid, where the row and column headings meet. Then choose Home > Format > AutoFit Row Height. This applies the command across the sheet, including rows that do not currently look problematic.

You can also select a range of row headings when only part of a sheet needs attention. For example, select rows 2 through 50 and run AutoFit to leave a title area or a carefully formatted footer untouched. To select nonadjacent rows, hold Ctrl on Windows while clicking their row numbers, then apply the command.

Hidden rows stay hidden; AutoFit does not make them visible. If a row seems to have been skipped, check whether it is hidden or excluded from the visible results by a filter. Unhide it or clear the relevant filter before adjusting it if you need to inspect its height. For a filtered list, fitting visible rows can be useful, but it does not change the fact that filtered-out records are not on display.

Why AutoFit May Not Work as Expected

Merged cells are a frequent cause of disappointing results. When a cell spans multiple columns, Excel may not calculate the needed wrapped-text height correctly with AutoFit. If a merged heading is clipped, a practical workaround is to unmerge the cells, set a suitable column width, turn on Wrap Text, and fit the row. If the visual design requires the merge, adjust the row height manually until the full heading is visible.

Another common issue is a row that was given a fixed height. Choose Home > Format > AutoFit Row Height to recalculate it rather than assuming a previous manual size will respond to later changes. If it still appears clipped, check that Wrap Text is enabled and that the row is not near Excel’s maximum height. A cell with a large amount of text may exceed what a single row can display.

Formatting can also affect the result. A larger font, bold text, or a different font face can require more vertical space. If a workbook is opened on a computer without the original font, Excel may substitute another font, changing line breaks and the apparent fit. Zoom affects how large the worksheet looks on screen, but it does not change the stored row height; do not use zoom as a fix for clipped content.

Finally, inspect the cell itself. Manual line breaks, blank lines, or text that was pasted from another application can create more displayed lines than expected. If the row is much taller than its neighbors, select the cell and review the formula bar or edit the cell to see whether the entry contains extra line breaks.

Manual Height, Limits, and Layout Choices

AutoFit is best when rows contain variable-length content and the goal is to show it without guessing. A manual height is often better for a report, form, or dashboard where consistent row sizes matter more than displaying every line at once. To set one, drag the boundary below a row number, or choose Home > Format > Row Height and enter a value.

Excel’s maximum row height is 409 points. If wrapped text needs more space than the row can provide, reduce the font size, widen the column, shorten the displayed content, or split the entry across multiple rows. You might also keep the full text in the cell but make the column wider for on-screen review. The right choice depends on whether the sheet is designed for reading, editing, or printing.

To restore content-based sizing after manually changing a row, select it and run AutoFit Row Height again. To make several rows uniform instead, select them and enter the same value through Row Height. These are different goals: AutoFit produces individually sized rows, while a fixed height produces a consistent grid.

Excel for Mac and Excel for the Web

In Excel for Mac, select the rows and use the Home tab’s Format menu to find AutoFit Row Height. You can also double-click the boundary below a row number. The Windows Alt, H, O, A KeyTip sequence is not the Mac equivalent, so use the menu or boundary method on a Mac.

Excel for the web also provides row sizing controls on the Home tab, including AutoFit Row Height in the Format menu in current layouts. The ribbon may look different in a narrow browser window, so expand the ribbon or use the row-heading boundary if you cannot see the command. In any version, confirm that the sheet is not protected from formatting changes; protection can prevent row-height adjustments unless the relevant permission is allowed.

Frequently Asked Questions

How do I make Excel automatically adjust row height? Select the rows and choose Home > Format > AutoFit Row Height. For wrapped text, enable Home > Wrap Text as well. Excel may not recalculate reliably for merged cells, so those rows can require manual sizing.

Why is Excel cutting off text after I use AutoFit? Check whether Wrap Text is enabled, whether the cell is merged, and whether the row has reached Excel’s height limit. Also look for manual line breaks or a narrow column that creates many wrapped lines. A manual AutoFit command can help after you correct the underlying layout.

Can I AutoFit all rows at once? Yes. Click the Select All button at the top-left of the worksheet grid, then choose Home > Format > AutoFit Row Height. This changes row heights across the selected sheet, so use a row range instead if you want to preserve a specially formatted area.

Does AutoFit Row Height work with merged cells? It may not calculate the height needed for wrapped text in merged cells. Unmerge the cells and fit the row if practical; otherwise, set the height manually and check that the full text is visible.

How do I return a row to its normal height? Select the row and run AutoFit Row Height to size it to its current content. If you want a standard, uniform height rather than a content-based one, use Home > Format > Row Height and enter the height you want.

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.