row autofit

[greg]

I am running excel 2003.
If I set a row to auto fit. and I set the cells to wrap text.
If I start typing text, it will wrap in the cells. growing the row height
as needed.

Now,
If I merge some cells. It will no longer grow the height to wrap text.

how come?
is there a way to merge cells and have the text wrap?
thanks

 

[Dave Peterson]

Merged cells won't autofit -- even if you try to manually autofit the row.

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

 

[Dave Peterson]

No, I don't.

thanks for the help
Do you know if it is fixed in 2007?

 

[greg]

thanks for the help
Do you know if it is fixed in 2007?