AUTO ROW HEIGHT

[manutt]

Why does auto row height not work in a particular sheet? I have followed all
the instructions regarding changing row height or making it automatic but I
hav a document in which many cells have hidden text in whichever view I use,
and remains hidden after printing. Of course I can manually adjust the height
but there are over 1000 rows in the document and I am looking for a generic
solution.

 

[Gord Dibben]

Do you have any "merged cells"?

These will prevent the rows autofitting.

You would need event code to get autofit to work.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which is all one line.

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


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

This feature only works if 1. Wrap Text is turned on, 2. or you entered the
text by press Alt+Enter where you want the wrap, 3. Only if the cells are not
merged.