Excel Guides

Adjusting Row Height when Wrapping Text in Excel

When you have text in a cell that is too long to fit within the width of the cell, you can use the Wrap Text command to make the text automatically wrap to the next line so that all of the text is visible. However, sometimes the row height doesn't adjust automatically and you end up with a lot of empty space below your wrapped text. Here's how to fix that:

  1. First, select the cells that you want to format.
  2. Then, go to the Home tab on the ribbon and click on Wrap Text. This will cause your text to wrap automatically.
  3. Now, go back to the Home tab and click on Format. In the Cells group, click on AutoFit Row Height. This will adjust the row height so that all of your wrapped text is visible.

Note:


If you have multiple lines of text in a cell, you can also use the
HTML tag to force a line break. For example:
This is line one.
This is line two.

Would become:

This is line one.
This is line two.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.