Autofit row height

O

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.
 
T

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
 
G

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
 
O

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.
 
O

Odie

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

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
 
O

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top