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

autofit text inside merged cells 4
Wrap text in merged cells VBA 2
Wrapping Text in Merged Cells - Excel 2002 3
wrapping text in merged cells 2
Text not showing in merged cells 1
Wrap Text doesn't work in Merged Cell 1
Getting word wrap to work in a merged cell 1
How to control row height and text wrap in non-merged cell ??? 2

Top