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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>