Wrap text in merged cells

[Jlorga]

Is there any way to wrap text in merged cells?

the wrap text property works fine if i have only a cell, but when i
merge cells it doesn't work, i tried even with alt+enter, and still no
wrapping ocurs.


Is there any way to do this?

Thanks,

 

[Dave Peterson]

Wrap text should work ok in a merged cell, but autofitting of the rowheight
won't.

You have to adjust that manually (or via a macro).

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Jlorga]

Hi,

yes, that helped.

thanks

Wrap text should work ok in a merged cell, but autofitting of th
rowheight
won't.

You have to adjust that manually (or via a macro).

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you ma
like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intr
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://www.excelforum.com/showthread.php?threadid=516674