To prevent Excel from auto wrapping text, right click on the row(s) and select Row Height from the popup menu. ![]() 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". How can I stop Excel from doing this?Īnswer: The problem is that Excel auto-sizes the row height when you paste text into 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. ![]() Question: First of all, I have the "wrap text" option unchecked in Microsoft Excel 2011 for Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |