Try adding alt-enters (to force new lines within the cell) every 80-100
characters. You should be able to see more.

Jon wrote:

I am inputting text to a spread sheet that has previously been formated by
somebody else. The cells have been merged and set to wrap text. Only an
amount of the text shows in the merged cells, even if I expand them. Double
clicking on the cells shows all the text but as soon as I come out it reverts
to show only part of the text. The whole text also shows in the formula bar.
Please help

--

Dave Peterson