display multiple lines of text within a merged cell automatically

S

sssizemore

I m trying to get my excel spreadsheet to automatically display several
sentences in a merged cell. It is really frustrating me as I have yet to find
out how to do this. I can get the sentences to display automatically if the
cells aren't meged by wrapping the text, but once I merge the cells it will
not automatically wrap the text even though the wrap text option is selected.
Any help would be greatly appreciated.
 
V

Vasant Nanavati

Sorry if this is not helpful, bit avoid merged cells! There are almost no
good reasons to use them. Use Center Across Selection instead (Format |
Cells | Alignment).
 
Top