Formatting Excel

[sniper2328]

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.

 

[Jacob Skaria]

Rows(1).wraptext=True

If this post helps click Yes

 

[Gord Dibben]

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

 

[Lauranator]

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.