Excel adjust row height upon merging 2 cell with word wrap

[Guest]

When I merge two cells in excel 2003 and format to word wrap, the row height
is not adjusting to show wraped text. I am forced to manually adjust row
height

 

[Dave Peterson]

That's the way excel works.

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

 

[Ken Wright]

Merging cells is something that most in here will avoid like the plague.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Ken Wright]

Sorry, meant to add - Format / cells / Centre across selection usually gives
the same visual effect without any of the usual associated hassles.

Regards
Ken.............