If you have lots of text in the cell (more than a 1000 characters???), you can
add alt-enters ever 80-100 characters (to force new lines within the cell).

You may have to adjust the rowheight to see the text, though.

Linda wrote:

i have a large amount of text in an Excel cell and it all shows but when i
click outside that cell, the last part disappears (it truncates in the middle
of a word). i have cells larger in other places in the worksheet. i tried
dragging down the cell size, merging the cells, and setting the size on that
row larger. same results each time. please help. Linda

--

Dave Peterson