Autofit Row Height

[Joe Blow]

I have a table that has cells with text. The cells are formatted for
"word wrap", and each cell has a different number of lines of text for
the given column width. If I do "autofit row height", the rows adjust
such that you don't see all the lines of text for some cells. I want
minimize the row height for all the cells, but I still want to be able
to read all the text in each cell.

I appreciate any help.

Thanks

 

[curllion]

you can select all rows and double click the border of whichever row



--
=====================================================
* ÔÚÎÒÇà´ºÄêÉÙµÄʱºò£¬ÓиöÅ®º¢Ô¸ÎªÎÒÈ¥ËÀ¡£ ¡¡¡¡ *
* ËýÒâÖ¾¼á¶¨µØ¶ÔÎÒ˵£¬ÄãÒªÊÇÔÙ²ø×ÅÎÒ£¬ÎÒ¾ÍÈ¥ËÀ£¡ *
* ÔÚÎÒÇîÀ§Áʵ¹µÄʱºò£¬ÓиöÅ®ÈËÔ¸ºÍÎÒ¹²¸°»ÆȪ£¡¡¡¡¡ *
* ËýÕ¶¶¤½ØÌúµÄ¶ÔÎÒ˵£¬ÄãÔÙ²»»¹Ç®£¬ÎҾͺÍÄãͬ¹éÓÚ¾¡£¡*
* *
* ÕŽ¨Æ½ *
=====================================================

 

[Joe Blow]

Curllion,

Yes, I tried that. What I'm saying is that, when I do an "autofit" it
shortens up the row height, but it shortens it up so much that it cuts off a
few lines of text in the cell. I need to minimize the row height, but I
don't want to cut off any text (i.e., i need all the text in the cell to
show up.). Keep in mind that my text is formated for "word-wrap".

Thanks for trying.

 

[Max]

Think it looks like autofit doesn't always work as expected,
and there may not be a cure, too,
going by this previous post by MVP Tom Ogilvy
: http://tinyurl.com/2nj3l

There's an MSKB article link given in the post by Tom:
http://support.microsoft.com/support/kb/articles/Q149/6/63.asp
XL: Wrap Text Does Not Adjust Row Height

 

[TKT-Tang]

Please refer to the following thread :-

http://groups.google.com/[email protected]

Regards.