Wrap text does not work

[PeterLai]

Dear all,

It seems that after changed the row height of the cell, tjhe wrap text does
not work .
How can I fix it?

Thank you in advance.

 

[David McRitchie]

Hi Peter,
Can you verify if it is wrap text that does not work or is it the automatic
row height adjustment that does not work.

Once you force the row height, Excel respects that and will not
change the height automatically for that row(s).

Here is a solution for a specific column by Bernie Dietrick.
http://google.com/groups?threadm=#[email protected]

Here is a more comprehensive solution for merged cells by Jim Rech in 1999
http://google.com/groups?thread=eJRhqgTf#[email protected]
watch for lines being split due to wrapping in the posting, which will show
up in RED as a syntax errors in the Visual Basic Editor (VBE) when a line
breaks into two lines.

If you think someone "improved" it you can search Google Groups for
EntireRow.AutoFit sub group:*Excel* wrap

Instructions to install a macro can be found at
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Help with searching newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm