format-row-autofit not working
 

Please help!
I have set several cells to merge and wrap-text. When I copy text from Word
into the cell, however, the row does not auto fit to the text. I've tried
going through the Format-Row-Autofit and double-clicking the row border and
neither have worked.

Autofit does not always work on Merged cells. Reference:
http://exceltips.vitalnews.com/Pages... ext_Wrap.html
*******************
~Anne Troy

www.OfficeArticles.com


"Redheads Rule" <Redheads wrote in message
...
Please help!
I have set several cells to merge and wrap-text. When I copy text from
Word
into the cell, however, the row does not auto fit to the text. I've tried
going through the Format-Row-Autofit and double-clicking the row border
and
neither have worked.

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

Redheads Rule wrote:

Please help!
I have set several cells to merge and wrap-text. When I copy text from Word
into the cell, however, the row does not auto fit to the text. I've tried
going through the Format-Row-Autofit and double-clicking the row border and
neither have worked.

--

Dave Peterson