some text shows in merged cells but not all

J

Jon

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixing text wrap in merged cells 1
Text wrap in merged cells 0
Merged cells stop wrapping 4
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Wrapping Text in Merged Cells - Excel 2002 3
Wrap text in merged cells VBA 2
autofit text inside merged cells 4
Merged cells/wrap text 1

Top