Fix Excel AutoFit Row Height for Wrapped Text
Question details
The user needs Excel to adjust row height to fit wrapped text without leaving unnecessary blank space.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Wrapped text is enabled and AutoFit Row Height is applied to a worksheet row.
- Observed behavior
- Excel leaves extra blank space after adjusting the row height.
Select an affected cell and check whether Home > Wrap Text is enabled. Also check whether the cell is merged and whether its text contains intentional line breaks.
Apply AutoFit Row Height to the affected rows
Use AutoFit to recalculate row height after checking the text and column width.
Click the row number beside an affected cell, or drag across row numbers to select multiple rows.
Drag the column boundary to the desired width. A narrower column can make wrapped text occupy more lines.
Choose Home > Format > AutoFit Row Height. Check whether the blank space is reduced.

Unmerge cells that prevent AutoFit from working
Use this method when wrapped text is in a merged cell and Excel does not calculate the row height correctly.
Remove unwanted line breaks and check formatting
Use this method if extra space remains after AutoFit and the cell is not merged.
Work with wrapped spreadsheet text in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files in WPS Spreadsheet to continue working with wrapped text and row formatting while migrating your documents.

Frequently Asked Questions
Why does AutoFit leave extra space below wrapped text?
Merged cells, manual line breaks, column width, or formatting in the row can affect the result. Check the affected cells, then select the row and choose Home > Format > AutoFit Row Height again.
Does AutoFit work with merged cells?
Excel may not calculate the correct row height for wrapped text in merged cells. Unmerge them using Home > Merge & Center > Unmerge Cells, or manually adjust the row height if the merged layout must remain.
How can I remove an extra blank line from a cell?
Double-click the cell, place the cursor next to the unwanted line break, and delete it. Press Enter, then apply Home > Format > AutoFit Row Height to the row.
Can another cell make the row taller?
Yes. A row must accommodate its cells, so wrapped text or a large font elsewhere in the row can increase its height. Check the other cells and their formatting on the Home tab.




