Make Autofit row height work with merged cells

[Guest]

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]

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

 

[Guest]

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.