I have a spreadsheet that has 2 columns with "Wrap Text" on and the rest off.
The rows that have multiple lines in the wrapped-text columns have row
heights that are auto-sized correctly. The rows that have no wrapped text
(single line all the way across) do not. Most (but, oddly, not all) have
extra space above them (the size of the font) that will not close up, no
matter what kind of autofitting you try. None of the cells are merged cells.
This has been happening for years and I've never figured out how to fix it,
short of manually sizing the offending rows.

"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

Samjoy wrote:

How can I get MS Excel to automatically re-size the height of the row when I
wrap text in merged cells?

--

Dave Peterson