Excel Cell Height Not Adjusting? Fix the Common Causes

Errors & fixes · Updated November 18, 2026

If an Excel cell’s height is not adjusting, select the affected row or rows and choose Home > Format > AutoFit Row Height. If that does not work, check for merged cells, disabled Wrap Text, hidden rows, a manually fixed height, or worksheet protection; each can prevent the row from showing all its content.

How Excel row height works

Excel sets height for an entire row, not for an individual cell. If one cell in row 12 needs more vertical space, the height of row 12 changes for every column, including columns whose cells are empty. This is why a tall entry can make the surrounding worksheet look uneven.

Row height is measured in points, a typographic unit, rather than in the number of lines of text. The height needed for a cell depends on such things as the font, font size, column width, and whether text wraps. A row can also have a manually assigned height that stays fixed until you change it or run AutoFit.

AutoFit estimates the height required to display the cell contents in the current layout. It does not continuously resize every row whenever the worksheet changes. For example, entering a longer sentence into a row that already has a set height may leave part of the sentence out of view until you apply AutoFit again.

AutoFit a row or a group of rows

In Excel for Microsoft 365 on Windows, use the ribbon to adjust the height:

  1. Select the row numbers on the left for the rows you want to fix. To select the whole sheet, click the triangle at the intersection of the row and column headers.
  2. Choose Home > Format > AutoFit Row Height.
  3. Check that the text is now visible. If several rows are affected, select all of them before using AutoFit.

There is also a quick mouse method: move the pointer to the lower boundary of a row number in the row headings, then double-click when the pointer changes to a row-resizing cursor. To fit several rows, select them first and double-click the boundary of one selected row. Excel applies the sizing to the selection.

On Windows, the ribbon key sequence Alt, H, O, A opens AutoFit Row Height. Press the keys in sequence rather than holding them all at once. In Excel for Mac, select the rows and use Home > Format > AutoFit Row Height; keyboard shortcuts can differ by keyboard and Excel release. Excel for the web also provides AutoFit Row Height under Home > Format, though the ribbon may look different in a narrow browser window.

Check Wrap Text and column width

AutoFit is most useful when Excel can see how many lines of text need to fit. If text wrapping is off, a long entry may continue visually across empty cells or appear cut off at the edge of a filled cell, rather than increasing the row height. Select the relevant cells and choose Home > Wrap Text, then run AutoFit Row Height.

Column width affects the result. A narrower column usually creates more wrapped lines and therefore a taller row; widening it may reduce the height needed. For example, a sentence that fits on two lines in a wide column might take five lines in a narrow one. If AutoFit seems to create an unexpectedly tall row, check the width of the column containing the longest text before setting the height manually.

Text alignment settings can also change how the content appears. Shrink to Fit reduces the displayed text size to fit the cell width instead of wrapping it into additional lines. If the text looks unusually small and the row does not grow, select the cell, open the Format Cells dialog, and inspect the Alignment options. Turn off Shrink to Fit if you want the text to wrap and the row to grow.

Merged cells are a common exception

AutoFit does not reliably calculate the height required by text in merged cells. A merged range spans multiple columns, so Excel cannot handle its width in the same straightforward way it handles a regular cell. The result can be a row that remains too short even after you choose AutoFit Row Height.

If the text is in a merged range, try temporarily unmerging the cells, applying Wrap Text, and fitting the row. You can then set a suitable row height manually before deciding whether to merge the cells again. Reapplying the merge may change how the text displays, so check the final result rather than assuming the earlier height will remain appropriate.

For worksheets that need frequent editing or reliable automatic sizing, consider using Center Across Selection instead of merging cells. In Format Cells, find this option under Alignment > Horizontal. It can make text appear centered across selected columns without joining the cells into one merged range. It is not a perfect substitute for every layout, but it avoids several problems that merged cells can cause with selecting, sorting, and resizing.

Look for hidden rows, filters, and outlines

A row set to zero height is hidden, so its contents cannot be inspected until you unhide it. Select the row headings above and below the missing row, right-click, and choose Unhide. You can also select the surrounding rows and use Home > Format > Hide & Unhide > Unhide Rows. If you cannot identify which rows are hidden, select the whole sheet first and use the same command.

Filters and outline grouping can also make rows disappear from view. A filter hides records that do not meet its criteria; it does not mean their heights are too small. Clear or change the filter if you need to see those records. If row numbers show outline controls, expand the relevant group with its plus sign before checking the row heights.

AutoFit only acts on rows that are available to adjust in the selection. If the row you expect to change is hidden, unhide it first. Also make sure you selected the row number, not just one cell in a different part of the sheet; selecting the full row makes it clear which row height Excel should calculate.

Check protection and manually set the height

A protected worksheet may prevent row formatting. If AutoFit is unavailable or does not change the selected rows, review the Review tab for Unprotect Sheet. If you have permission to edit the sheet, unprotect it, adjust the rows, and protect it again if needed. On a protected sheet, the person who set the protection may need to allow formatting rows; otherwise, a user may be able to edit permitted cell values but not change row height.

When you need a specific layout rather than a content-based fit, set a height directly. Select the row headings, choose Home > Format > Row Height, enter a value, and confirm. This is useful for forms, print layouts, or headings that need consistent spacing. It is less flexible than AutoFit: if you later add more text or change the font, the fixed height may once again hide part of the content.

Excel limits row height, so exceptionally large amounts of wrapped text cannot be shown in one row at any height. If a row is already very tall, split the text across multiple rows, widen the column, or use a separate area for the full notes. For a few clipped lines, a modest manual increase may be enough; for ongoing data entry, AutoFit is generally easier to maintain.

Why the problem can return

Row height is a property of the worksheet layout, not a permanent feature of the text. Pasting content, changing a font, adjusting column widths, or adding line breaks can make a previously adequate height unsuitable. After a major layout change, select the relevant rows and run AutoFit again.

Line breaks entered within a cell can create multiple lines even when the text is not long enough to wrap naturally. On Windows, Alt+Enter inserts a line break while editing a cell; on Mac, the equivalent depends on the keyboard and Excel version, and commonly uses Control+Option+Return. If the row does not show all lines afterward, confirm that Wrap Text is enabled and AutoFit the row.

Zoom does not change the underlying row height. It changes how large the worksheet appears on screen, so a row may look compressed at a low zoom level even though its measured height is unchanged. Likewise, print scaling changes how a sheet is fitted to a printed page; it is not a substitute for adjusting row height in the worksheet.

AutoFit versus a fixed height

Choose AutoFit when content varies between records, such as comments or descriptions that have different lengths. It helps reveal the complete entry without guessing a height for each row. The trade-off is that rows can become very tall when a cell contains a long paragraph, making it harder to scan a large table.

Use a fixed height when consistency matters more than displaying every word at once, such as in a compact data-entry form. In that case, consider whether users can read the full content in the formula bar or edit the cell when needed. A practical compromise is to set a standard height for ordinary rows and AutoFit only the rows containing longer notes.

When a worksheet is used by other people, make the display choice deliberate. If the full text must be visible for review or printing, favor wrapping and AutoFit, while keeping column widths readable. If the sheet is a compact dashboard, a consistent height may be more useful, provided important content is not silently hidden.

Frequently Asked Questions

Why does AutoFit Row Height do nothing?
Check whether the row is hidden, the sheet is protected, or the text is in a merged cell. Also confirm that you selected the intended row and that Wrap Text is enabled if the text should occupy multiple lines.

How do I make Excel cells expand automatically as I type?
Turn on Wrap Text for the relevant cells and run AutoFit Row Height. Excel does not always resize a row automatically after later edits, so you may need to apply AutoFit again when the content or layout changes.

Why is only part of my cell text visible?
The row may have a fixed height, or wrapping may be off. Select the row, enable Wrap Text if appropriate, and choose Home > Format > AutoFit Row Height. Also check for Shrink to Fit, which changes displayed text size rather than increasing row height.

Can Excel AutoFit the height of merged cells?
Not reliably. Unmerge the range and fit the row, or enter a suitable height manually. If the layout allows it, Center Across Selection can provide a centered appearance without merging cells.

Does changing zoom fix a row that looks too short?
No. Zoom changes the on-screen scale, not the row’s actual height. Use AutoFit Row Height or set a specific height to change the worksheet layout.

Why does a row become too short again after I edit it?
A change to the text, font, column width, or line breaks can increase the space required. Run AutoFit again, or use a suitable fixed height if the worksheet needs a consistent layout.

Related

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.