I'm trying to find out how to format a row to automatically adjust height to
display ALL wrapped text in a cell. Does anybody know how to do this? I know
it can be done, but i don't know how to do it.

Rows(1).wraptext=True

If this post helps click Yes
---------------
Jacob Skaria


"sniper2328" wrote:

I'm trying to find out how to format a row to automatically adjust height to
display ALL wrapped text in a cell. Does anybody know how to do this? I know
it can be done, but i don't know how to do it.

Depends upon how much text is in the cell.

You can enter 32767 characters in a cell but only 1024 will display in the
cell.

Add an Alt + Enter linefeed every 100 chars to increase that display limit.

Also, if the text is in a merged cell this disables row autofitting and row
has to be manually fitted.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 10:40:05 -0700, sniper2328
wrote:

I'm trying to find out how to format a row to automatically adjust height to
display ALL wrapped text in a cell. Does anybody know how to do this? I know
it can be done, but i don't know how to do it.

You can highlight the entire row by clicking on the Row number, then go up to
the Home tab and click Wrap Text. This will make all text entered in that
row be wrapped text.

Hope this helps.

--
--Laura - MS Office 2007 Professional user on Windows XP - SP3


"sniper2328" wrote:

I'm trying to find out how to format a row to automatically adjust height to
display ALL wrapped text in a cell. Does anybody know how to do this? I know
it can be done, but i don't know how to do it.