Make Autofit row height work with merged cells

When a group of cells in a row are merged and the text wraps to two or more
lines, double-clicking the row border just to the left of column A (or
Format/Row/Autofit) auto-heights the row to one line of text. Either of
these actions should heighten the row to fit the text in the merged cells.

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

Franketh wrote:
>
> When a group of cells in a row are merged and the text wraps to two or more
> lines, double-clicking the row border just to the left of column A (or
> Format/Row/Autofit) auto-heights the row to one line of text. Either of
> these actions should heighten the row to fit the text in the merged cells.

--

Dave Peterson

Dave,
Thanks for the information. While I like macros, I use them sparingly, and
this issue is a "feature" Microsoft should fix.

To be honest, when creating this post I thought I was making a suggestion
directly to MS. My mistake for not paying closer attention.

"Dave Peterson" wrote:

> 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
>
> Franketh wrote:
> >
> > When a group of cells in a row are merged and the text wraps to two or more
> > lines, double-clicking the row border just to the left of column A (or
> > Format/Row/Autofit) auto-heights the row to one line of text. Either of
> > these actions should heighten the row to fit the text in the merged cells.
>
> --
>
> Dave Peterson
>