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

Yes you can use wrap text and merge in a cell.
Highlight the cells you want to merge together
Formatcells
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
on the left or going through FormatRowheight


"Elizabeth" wrote:

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

merge is more than one cell

--
Don Guillett
SalesAid Software

"Elizabeth" wrote in message
...
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

Elizabeth

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm


The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 07:01:05 -0800, Elizabeth
wrote:

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

On Tue, 15 Mar 2005 07:01:05 -0800, Elizabeth
wrote:

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

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.