Fix Excel for Mac Row Height Not Adjusting to Wrapped Text
Question details
Make Excel 2016 for Mac adjust row height so all wrapped text is visible.

- 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.
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.
Use AutoFit Row Height for the affected rows
Use AutoFit to resize rows that have a fixed height and are hiding wrapped text.
Click the row number for an affected row, or drag across multiple row numbers to select them.
On the Home tab, select Format > AutoFit Row Height. Alternatively, use Format > Row > AutoFit from the menu bar.
Drag the right edge of the column heading to change its width, then apply AutoFit Row Height again.

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.

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.




