Excel adjust row height upon merging 2 cell with word wrap
 

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

That's the way excel works.

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

RT wrote:

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

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 :-)
------------------------------*------------------------------*----------------


"RT" wrote in message
...
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

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

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

"Ken Wright" wrote in message
...
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 :-)
------------------------------*------------------------------*----------------


"RT" wrote in message
...
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