Hi there,
I have merged cell, and have long text in it. But when I did with wrap text,
the row width is not expanding to show all the text.

Any help would be appreciated.

Thanks.

Do it manually.

or...

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

wana be xl master wrote:

Hi there,
I have merged cell, and have long text in it. But when I did with wrap text,
the row width is not expanding to show all the text.

Any help would be appreciated.

Thanks.

--

Dave Peterson

Dave,
Thanks for your help, I'll ask my users to do it manually. In the mean time
I'll study those script.
wana be xl master

"Dave Peterson" wrote:

Do it manually.

or...

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

wana be xl master wrote:

Hi there,
I have merged cell, and have long text in it. But when I did with wrap text,
the row width is not expanding to show all the text.

Any help would be appreciated.

Thanks.

--

Dave Peterson