11 replies
by garymac12 Accepted solution
by pringles86 Accepted solution
Right click the cell you are going to paste to. Then select "Format Cells...", click the "Alignment" tab, check the "Word Wrap" checkbox, click ok, and paste your text.
Let me know if this works out for you.
by garymac12 Accepted solution
Nope. It still looks at every carriage return as an opportunity to skip to the next cell.
Word wrap allows me to type in and wraps as long as I do not hit the enter key.
by jennkennedy Accepted solution
by garymac12 Accepted solution
by wilecoyote22 Accepted solution
You paste normally but the text shows up as one huge line going off the spreadsheet. Now right click and select format cell (you could highlight multiple cells if you want). Now under format cells go to the Alignment tab. There check the "wrap text" option.
Now your huge line of text will wrap to a single cell. Remember that you may need to adjust your cell to your liking. I suggest you adjust the width manually and just double click on the line under the row number. That will make Excel autosize the cell vertically.
Have fun
by mark.ivanowski Accepted solution
by khanhvn Accepted solution
by tobif Accepted solution
by mcwong1 Accepted solution
We had the same problem -- pasting a chunk of text that included several paragraphs and numbered lines into a single cell -- except Excel automaticallyi distributes it into multiple cells.
Solution: Instead of psting into the CELL, click on the cell then paste into the data-entry bar above.
Bingo -- everything is in just that one cell.....!
by itpixie Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending