Wrap text in mege cells

[wana be xl master]

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]

Do it manually.

or...

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

 

[wana be xl master]

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