As discussed earlier, this utility is based on the size of text present in a particular row. There are two ways of auto-adjusting the row height in Excel. Method#1 – Auto Adjust Row Height in Excel. Step 1: Select all the rows for which you wanted to autofit the row height based on the text size within cells. In this case, I will select all. Use the following steps to apply Wrap Text using a VBA Code. Define the cell where you want to apply the wrap text using the range property. Type a dot to see the list of the properties and methods for that cell. Select the “WrapText” property from the list. Enter the equals sign “=” and the type TRUE to turn the wrap text ON. Merged Cell Row Height. Usually, if you add more text to a single cell, and Wrap Text is turned on, the row height automatically adjusts, to fit the text. When the cells are merged in row 10, the row height has to be manually adjusted when the text changes. Select the cells. On the Home tab, under Alignment, click Wrap Text, and then click Shrink Text To Fit. Data in the cell reduces to fit the column width. When you change the column width or enter more data, the font size adjusts automatically. Reposition the contents of the cell by changing alignment or rotating text.

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

Excel 2011 Auto Adjust Cell Height For Wrapped Text Message

In Microsoft Excel, if you manually modify the height of a row and then format a cell in that row to wrap text, Excel does not change the height of the row to fit all the text in the cell.

Cause

This behavior occurs if you have manually modified the height of the row.

Workaround

Automatically Adjust Row Height To Fit Text In Excel

To adjust the height of the row to fit all the text in a cell, follow these steps:

Excel 2011 Auto Adjust Cell Height For Wrapped Text Messages

1. Select the row you want to adjust the height.

2. In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Row on the Format menu, and then click AutoFit.

   In Microsoft Office Excel 2007 and later versions, click the Home tab, click Formatin the Cells group, and then click AutoFit Row Height.

If your Excel sheet contains merged cells, visit the following Microsoft website:

Excel Auto Row Height For Wrapped Text

Status

Excel 2011 Auto Adjust Cell Height For Wrapped Text Symbol

This behavior is by design.