Spreadsheet 123 Excel 2007 FAQs: Stop Wrap text

Also learn how to stop Excel from automatically "wrapping text" when pasting in Excel 2003/XP/2000/97.

Question:  First of all, I have the "wrap text" option unchecked in Excel. However, when I paste a large amount of text into Excel (especially text with line feeds in it), Excel automatically resizes my row height and turns the "wrap text" feature on. How can I stop Excel from doing this?

Answer:  The problem is that Excel auto-sizes the row height when you paste text into Excel. So when you paste text, as you can see below, Excel will increase your row height and set your cell's attributes to "wrap text".

To prevent Excel from auto wrapping text, right click on the row(s) and select Row Height from the popup menu.

When the Row Height window appears, you don't need to change the row height...but only click on the OK button. This will let Excel know that you want a fixed size for the row height, instead of auto-sizing it.

Now when you paste text into the cell, the row height should remain the same.