How to Fix Excel Wrap Text Feature when Your Rows Stop Expanding

In Excel, you will frequently have text that is longer than the cell width and you will often use the Wrap Text feature to make it more readable.

Wrap Text

However, have you ever had a row that stopped expanding even though Wrap Text alignment feature was activated in Excel?

It is so frustrating.  And it only happens to some cells.  Ever wonder why and how to fix it?

Excel will automatically adjusts row height to best fit the text when wrap text is selected.





However, this won’t work in the following cases:

  • Merged Cells
  • Row Height of the Cell Was Previously Changed

However, you can correct this issue by simply resetting the row height to best fit by double clicking in between the bottom of the row and above the next row as you see here:

Wrap Text Best Fit Row Height 2

Your cursor will change to a double arrow and then you will double click to activate the best fit feature in Excel for the row height.

Watch this quick video to see what is causing it and how to fix it.



Video Demonstration:

What other things in Excel frustrate you and how did you fix it?  Let me know in the comments below.

Steve=True





4 COMMENTS

  1. This solution doesn’t seem to work when I have merged cells in Excel 2016. I need to maintain cell width and want text to wrap and resize cell height when necessary in merged cells

    • Thanks for the comment Brian, I am not sure how it reacts to merged cells in any version. Perhaps that is an issue.

LEAVE A REPLY

Please enter your comment!
Please enter your name here