some text shows in merged cells but not all
 

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

some text shows in merged cells but not all
 

Change formatting in the cell from 'text' to 'general'.
--
-Kaman
The IT dept people call before they call the real IT dept.


"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

some text shows in merged cells but not all
 

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