No matter what I do, I can’t seem to fix this issue I’m having.
In the spreadsheet I’m working on, one of the cells contains two large paragraphs. For some reason, even though the cell is formatted to wrap text, the second paragraph does not wrap. I’ve deleted the row and inserted a new row - doesn’t fix it. I’ve highlighted only the second paragraph and it indicates that it is wrap text. I’ve removed it from the cell, removed all formatting in Word, reinserted it, and it’s still not wrapping.
I would try separating the second paragraph from the first and put it in its own cell and try making it wrap there. If you can get it to wrap on its own, paste it back into the first cell and hope.
First of all, what version of Excel are you using? Are you saying you have a cell where one paragraph is wrapped, but another paragraph is not wrapped (runs into the adjacent cell)? I don’t think that’s possible. A cell has wrapped text or it doesn’t. Are you sure all the text is in one cell? Maybe it’s two cells with the a border missing.
The version I am using is 2003. Yes I am sure it’s all in one cell. I’ve cut and pasted it into a new cell and it looks fine, then back into a new cell I’ve created and the second paragraph still won’t wrap.
I cut the text and paste it into a new cell in another area. It’ll wrap properly. Then I delete the offending row and insert a new row. I paste it back in and the same problem happens again.
When you insert a row, the new row inherits all the format settings from the row above it.
Find an existing row with normal formatting, insert your text to make sure it appears correctly. Cut and paste (choose paste special, insert cells) into the area you want.