MrExcel.com - Your One Stop for Excel Tips & Solutions

Excel Text Wrap

Posted by Tom on October 18, 2001 4:44 AM

Within a cell a have over 300 words, the cell has text wrap on, after about 250 words the cell does not show the all of the text in the cell. It seems to cut off after so many words. The only way to see all of the text is click on the cell and press the F2 key and then click in the cell. The text will all be displayed, when I click on another cell, it seems to display so many words again. I have resized the cell and done everything I can think of. Any help would be appreciated.

Posted by MrExcel on October 18, 2001 6:47 AM

Excel does a horrible job any time the length of the cell exceeds 1024 characters. Watch the site for a tip of the week dealing with these LongText issues.

I've found that Edit - Fill - Justify won't work with cells longer than 256 characters and that Format - Row - Autoheight will not work if the cell is over 1024 characters.