can wrap text and merge be used together?

E

Elizabeth

I thought that I was able to use wrap text and merge in a cell together but
when I use them together it doesn't wrap.

Please let me know if I can use the two controls together.

Thank you
 
W

ww

Yes you can use wrap text and merge in a cell.
Highlight the cells you want to merge together
Format>cells
click on Alignment Tab
choose the wrap text and merge cells boxes

That should do it although excel usually doesn't adjust the row
height to show the wrap so you'll probably have to by dragging
 
D

Don S

I thought that I was able to use wrap text and merge in a cell together but
when I use them together it doesn't wrap.

Please let me know if I can use the two controls together.

Thank you
Click to expand...

It should work. It is more obvious if you center the text and the
column width is less than the text string. Try that & see if it does
what you want. I do it all the time. You may have to adjust the row
height manually - my Excel 2003 doesn't always automatically adjust.

Don S.
 
Top