How to Set Automatic Row Height for Wrapped Text in Excel

Excel is a powerful tool that can help you manage and analyze data with ease. One of the most useful features of Excel is the ability to wrap text within a cell. However, when you wrap text, it can sometimes be difficult to read because the row height does not adjust automatically. In this article, we will show you how to set automatic row height for wrapped text in Excel.

Step 1: Select the Cells

The first step is to select the cells that contain the wrapped text. You can do this by clicking and dragging your mouse over the cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell in the range.

Step 2: Open the Format Cells Dialog Box

Next, you need to open the Format Cells dialog box. You can do this by right-clicking on the selected cells and choosing Format Cells from the context menu, or by clicking on the Home tab in the ribbon and then clicking on the Format Cells button in the Cells group.

Step 3: Select the Alignment Tab

In the Format Cells dialog box, select the Alignment tab. This is where you will find the option to set the row height for wrapped text.

Step 4: Check the Wrap Text Box

Make sure that the Wrap Text box is checked. This will ensure that the text is wrapped within the cell.

Step 5: Set the Row Height

Finally, you need to set the row height for the cells. To do this, check the box next to “Row height is” and enter a value in the box. You can also use the up and down arrows to adjust the row height.


Setting automatic row height for wrapped text in Excel is a simple process that can make your data easier to read and understand. By following these steps, you can ensure that your text is wrapped within the cell and that the row height adjusts automatically to fit the text. With this knowledge, you can take your Excel skills to the next level and create professional-looking spreadsheets that are easy to read and understand.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.