Excel Column Height: AutoFit Rows and Fix Wrapped Text

Excel does not have a separate column-height setting: columns have width, while rows have height. To make text fit vertically, select the relevant row or cells, then choose Home > Format > AutoFit Row Height; for wrapped text, turn on Home > Wrap Text first. You can also double-click the boundary below a row number to AutoFit that row.

Why Excel uses row height, not column height

A worksheet is a grid of columns and rows. Column width controls how much horizontal space a cell has; row height controls how much vertical space it has. If a long entry looks cut off at the bottom, the row height is the setting to adjust. If it runs into the next cell or appears cut off at the right edge, the column may be too narrow.

Excel measures row height in points, a typographic unit, and column width using a character-based measure related to the default font. You generally do not need to convert either measurement. AutoFit calculates the row height needed to display the current cell contents, taking the column width and text formatting into account. A narrower column can make a sentence wrap onto more lines, so the same row may need more height after you reduce column width.

This distinction is useful when preparing a report: widening a column can reduce the height needed for wrapped entries, while increasing row height alone will not make a long, unwrapped line fit horizontally. Choose the dimension that matches the problem.

AutoFit row height for a worksheet or selection

In Excel for Microsoft 365 on Windows, use the ribbon command when you want Excel to calculate heights from the current contents:

Select the rows, cells, or range you want to adjust. To select the entire worksheet, click the Select All button at the intersection of the row and column headings.
Choose Home > Format > AutoFit Row Height.
Check a few of the tallest or most text-heavy rows. If text is still clipped, see the troubleshooting section below.

You can also select one or more row headings and double-click the lower boundary of any selected row heading. Excel adjusts the selected rows individually. Dragging a row boundary instead sets a chosen height manually; it does not calculate a fit.

On Windows, the ribbon KeyTip sequence for the command is Alt, H, O, A: press the keys in sequence rather than all at once. KeyTips can vary with ribbon layout or application version, so the Home > Format menu is the dependable route if the sequence differs. On Mac, use the Home tab’s Format menu and choose AutoFit Row Height; Windows Alt-key sequences do not apply. Excel for the web also offers row-height adjustment through the Home tab’s Format options, though the ribbon layout can differ slightly.

AutoFit only selected rows

For a large worksheet, it is often better to adjust only the rows that need it. Select a block of cells in those rows, or click and drag across their row numbers, then choose Home > Format > AutoFit Row Height. Selecting cells in a row is enough: Excel adjusts the height of each row represented in the selection.

To pick nonadjacent rows on Windows, hold Ctrl while clicking their row headings, then run AutoFit Row Height. On Mac, use Command while selecting separate row headings. If you select whole rows by clicking their numbers, the change applies across the worksheet width, not just to the cells that contain text. This can be helpful when other columns in those rows also contain wrapped notes.

If you want a uniform height rather than a calculated one, select the row headings and choose Home > Format > Row Height, then enter a value. This is a fixed setting: it can leave text clipped if later edits need more space, so use AutoFit when the goal is to fit current content rather than standardize the layout.

Wrap text before fitting long entries

AutoFit cannot make a long sentence display on multiple lines unless wrapping is enabled. Select the cells, choose Home > Wrap Text, and then run AutoFit Row Height. The cell contents remain in one cell; Excel displays them across additional lines within the existing column width. This is useful for headings, addresses, descriptions, and notes where widening a column would make the whole worksheet unwieldy.

For example, suppose column C contains product descriptions and is deliberately kept narrow so that columns D and E remain visible. Turning on Wrap Text lets a description occupy several lines in its row. AutoFit then increases that row’s height to show those lines. If you later widen column C, the description may take fewer lines; run AutoFit again if the row retains excess height.

To insert a deliberate line break within a cell, edit the cell and press Alt+Enter on Windows at the point where the next line should begin. On Mac, the line-break shortcut depends on the keyboard and Excel version; use the in-cell editing shortcut shown for your version rather than assuming the Windows combination works. A manual line break is different from automatic wrapping: it remains at the chosen position even if the column width changes.

What AutoFit changes—and what it does not

AutoFit is a command that calculates a suitable height from the cell contents as they exist at that moment. It is not a standing instruction that promises to resize every row whenever future data changes. After pasting longer text, changing a formula result, altering the column width, or changing formatting, run AutoFit again if the display no longer fits.

It changes row height, not column width, font size, or the contents of a cell. It also does not shorten text or remove line breaks. If the calculated height becomes large, the cause may simply be a narrow column, a long entry, or a large font. Decide whether the best layout is a taller row, a wider column, shorter wording, or a smaller font rather than forcing one setting to solve every case.

AutoFit is based on visible content and formatting, not on a desired page layout. It may therefore produce rows of different heights. If a printed report needs consistent spacing, fixed row heights can look more orderly, but they may crop content. Review both on-screen readability and print preview when the worksheet is intended for printing.

Common AutoFit problems and practical fixes

Text is still cut off: Confirm that Wrap Text is on if the text needs multiple lines, then run AutoFit again. Also check that the row is not hidden or set to a fixed height that needs to be recalculated.
The row is much taller than expected: Check for an unusually narrow column, a large font, or a manual line break. Widening the column or removing an unnecessary break can reduce the needed height.
Cells are merged: AutoFit does not reliably calculate row height for merged cells. If practical, unmerge the cells and use Wrap Text. Otherwise, adjust the row height manually and inspect the result.
Only part of the worksheet changes: The command affects the rows represented in the selection. Select the row headings or the full sheet before running it if you want a broader change.
Text appears clipped even after adjusting height: Check for adjacent merged cells, unusual font formatting, or a row height set manually. Reapplying AutoFit may help with ordinary cells, but merged-cell layouts often require manual adjustment.

One common misconception is that AutoFit makes every column wide enough for its longest entry. That is a different command, AutoFit Column Width, found under Home > Format. It changes horizontal width, not vertical height. For a wrapped paragraph, use Wrap Text and AutoFit Row Height; for a one-line label cut off on the right, consider AutoFit Column Width instead.

Choosing between AutoFit and a fixed height

Use AutoFit when complete visibility matters more than uniform row sizes, such as in a data-entry sheet or a list containing notes of different lengths. Use a fixed row height when a form, schedule, or presentation-style table needs consistent spacing and the content is known to fit.

For a table with mixed content, a practical approach is to wrap the description column, AutoFit the affected rows, and then review the tallest entries. If one unusually long note makes a row impractically tall, consider widening the column, shortening the text, or placing detailed notes in a separate column. Avoid reducing font size across the whole sheet just to accommodate one outlier.

If you need future entries to fit automatically, Excel does not provide a universal AutoFit-on-every-change setting for row height. You can use a fixed layout and check new entries, rerun AutoFit when needed, or use a macro-based solution. Macros require care: save a copy before running one, because macro actions generally cannot be undone with Ctrl+Z. For most workbooks, the built-in command is simpler and safer.

Frequently Asked Questions

Can Excel automatically adjust row height when I type?
Excel may resize ordinary rows in some situations, but AutoFit is not a guaranteed ongoing rule for every edit. Wrapped text, fixed heights, merged cells, and changes to formula results can leave content clipped. Run Home > Format > AutoFit Row Height after changes when necessary.

How do I AutoFit all rows in Excel?
Click the Select All button above row 1 and to the left of column A, then choose Home > Format > AutoFit Row Height. You can also select the whole sheet with Ctrl+A on Windows, but inside a table or data region it may take more than one press to expand the selection; the Select All button is clearer.

Why does AutoFit not work with merged cells?
Excel has difficulty calculating a suitable height when text spans merged cells, so the result can be too short or otherwise incorrect. Unmerge the cells if possible, enable Wrap Text, and AutoFit again. If the merged layout must remain, set the row height manually and verify that all lines are visible.

What is the shortcut to AutoFit row height?
In Excel for Windows, press Alt, then H, O, A in sequence to use the ribbon KeyTips for Home > Format > AutoFit Row Height. If that sequence is unavailable in your build, use the ribbon menus. Mac users should use Home > Format because the Windows KeyTip sequence is not the Mac equivalent.

How do I make text fit without making the row very tall?
Turn on Wrap Text and consider widening the column so the text breaks into fewer lines. You can also shorten the entry or remove unneeded manual line breaks. Increasing the row height alone reveals more lines but does not reduce the amount of vertical space the text requires.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.