Autofit row height

[Odie]

I am trying to make the height of a row change automatically. I know that
format>row>autofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.

 

[Tom Hutchins]

I don't know if your problem has the same cause as mine, but I had a
worksheet with cells which autosized much wider (column) or taller (row) than
necessary. The problem turned out to be the font, which was Courier. When I
changed the font to Arial, autosizing worked as expected.

Hope this helps,

Hutch

 

[Gord Dibben]

Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP

 

[Odie]

Thanks for the response. Yes, merged cells are involved. I did not realize
this would be an issue. I often use merged cells, so I would appreciate
knowing about event code.

Thanks.

 

[Gord Dibben]

Odie

Check out this google search thread from June 2007

http://tinyurl.com/5pua8z

Note: an "Odie" has taken part............coincidence?


Gord

 

[Odie]

Thank you, your response has been helpful. And yes, Odie is a quite a
coincidence. It was not me.

 

[Gord Dibben]

Blow away those insidious merged cells and your Excel worksheet life will be
much easier.

I know they have their uses for presentation but they may be close to the
greatest problem-causer we see.

Thanks for the feedback.


Gord

 

[Odie]

Thanks again. That's what I decided to do. I don't feel comfortable dealing
with code, so I redesigned the worksheet to eliminate the merged cells.
However, this answered my question about why autofit only works sometimes.
That was helpful.

Thanks.