Formatting Issues

Fix Excel AutoFit Row Height for Wrapped Text

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 872 views

Question details

The user needs Excel to adjust row height to fit wrapped text without leaving unnecessary blank space.

Fix Excel AutoFit Row Height for Wrapped Text
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.
Before you start

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.

Solution 1Recommended

Apply AutoFit Row Height to the affected rows

Use AutoFit to recalculate row height after checking the text and column width.

1
Select the rows

Click the row number beside an affected cell, or drag across row numbers to select multiple rows.

2
Check the column width

Drag the column boundary to the desired width. A narrower column can make wrapped text occupy more lines.

3
Apply AutoFit

Choose Home > Format > AutoFit Row Height. Check whether the blank space is reduced.

Apply AutoFit Row Height to the affected rows
Free Microsoft Office alternative

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.

Edit wrapped text and adjust row heights in WPS SpreadsheetOpen and save Microsoft Excel formats, including XLSX and XLSUse a familiar interface for everyday spreadsheet tasksWork with a free, lightweight office suite
microsoft office alternative - wps office

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.