Meged Cells and Wrap Text

[Guest]

After merging several cells to create a row, and selecting "wrap text" for
the merged cells, the row will not automatically expand to show all of the
text. Is there a way to format the row to auto expand? Using Excel 2000.

 

[Dave Peterson]

Do it manually.

or...

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