Text Wrap Issue

[clara]

Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara

 

[Gord Dibben]

Wrap Text and Format>Rows>Autofit should do what you want.

If a row has been manually set to a height, it will not expand untill you have
reset to Autofit.

UNLESS you have merged cells, in which case Autofit won't work and rows have to
manually adjusted or adjusted by sheet event code.

See google search thread for code by Greg Wilson

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

 

[clara]

Hi Gord,

Thank you very much for your help! I often use the microsoft's news group,
but how can I use the google search thread.?

Clara

 

[clara]

Hi Gord,

AutoFit seems only have one state, I can not change it from the meun. How
can change it ?

Clara

 

[Gord Dibben]

Best is to use Ron de Bruin's google search add-in.

http://www.rondebruin.nl/Google.htm

To go to google search directly use this URL

http://tinyurl.com/6pksz3

To go to Greg's message just double-click the URL I posted earlier.


Gord

 

[Gord Dibben]

Don't understand the question.

Format>Row>Autofit can be off or on.


Gord