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?thre...%40tkmsftngp05

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 wrote:
>
> 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,
>
> --
> Jlorga
> ------------------------------------------------------------------------
> Jlorga's Profile: http://www.excelforum.com/member.php...o&userid=31707
> View this thread: http://www.excelforum.com/showthread...hreadid=516674

--

Dave Peterson

[Jlorga]

Hi,

yes, that helped.

thanks

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?thre...%40tkmsftngp05

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 wrote:
>
> 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,
>
> --
> Jlorga
> ------------------------------------------------------------------------
> Jlorga's Profile: http://www.excelforum.com/member.php...o&userid=31707
> View this thread: http://www.excelforum.com/showthread...hreadid=516674

--

Dave Peterson