totn Excel

MS Excel 2007: Stop wrap text when pasting

This Excel tutorial explains how to stop the text from wrapping when pasting into cells in Excel 2007 (with screenshots and step-by-step instructions).

Question: First of all, I have the "wrap text" option unchecked in Microsoft Excel 2007. 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".

Microsoft Excel

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

Microsoft Excel

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.

Microsoft Excel

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

Microsoft Excel