Formatting Issues

Fix Excel for Mac Row Height Not Adjusting to Wrapped Text

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

Make Excel 2016 for Mac adjust row height so all wrapped text is visible.

Fix Excel for Mac Row Height Not Adjusting to Wrapped Text
Product
Microsoft Excel 2016 for Mac
Device & OS
Mac
Scenario
A user wants a row to expand automatically to display wrapped cell contents.
Observed behavior
Wrapped text is not fully visible because the row height does not adjust.
Before you start

Select an affected cell and check that Home > Wrap Text is enabled. Also check whether the cell is merged, as AutoFit may not work as expected with merged cells.

Solution 1Recommended

Use AutoFit Row Height for the affected rows

Use AutoFit to resize rows that have a fixed height and are hiding wrapped text.

1
Select the affected rows

Click the row number for an affected row, or drag across multiple row numbers to select them.

2
Apply AutoFit

On the Home tab, select Format > AutoFit Row Height. Alternatively, use Format > Row > AutoFit from the menu bar.

3
Adjust the column if needed

Drag the right edge of the column heading to change its width, then apply AutoFit Row Height again.

Use AutoFit Row Height for the affected rows
Check merged cells: If AutoFit does not resize a row containing merged cells, unmerge the cells using Home > Merge & Center and try again, or drag the row boundary to set the height manually.
Free Microsoft Office alternative

Work with Wrapped Spreadsheet Text in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for Excel files, making it easy to move spreadsheet work to WPS Spreadsheets. It does not repair Excel for Mac itself.

Use text wrapping and row-height controls in WPS Spreadsheets.Open and edit Microsoft Excel XLS and XLSX files.Work in a familiar, easy-to-use spreadsheet interface.Move existing spreadsheet files to a lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Where is AutoFit Row Height in Excel for Mac?

Select the affected rows, then choose Home > Format > AutoFit Row Height. You can also use Format > Row > AutoFit in the menu bar.

Why is wrapped text still cut off after I use AutoFit?

Check whether the cell is merged, because AutoFit may not resize rows containing merged cells. Unmerge it with Home > Merge & Center, or drag the row boundary to increase the height manually.

How does column width affect wrapped text?

A narrower column generally creates more lines of wrapped text. Drag the column heading's right edge to adjust the width, then use Home > Format > AutoFit Row Height.

How do I turn on Wrap Text in Excel 2016 for Mac?

Select the cells and click Wrap Text on the Home tab. Then apply AutoFit Row Height if the row does not expand enough to show the contents.