Format/Row/Autofit

G

Guest

Can someone please tell me why my text will not fit in
Autofit row. It just needs to be a little bit wider. It
never used to do this, is it because I'm now using Windows
XP with Excel 2000?
 
G

Gord Dibben

Wider/skinnier refers to Column.

Taller/shorter refers to Row.

Try Format>Column>Autofit.

Gord Dibben Excel MVP
 
G

Guest

So sorry, I meant taller, thank you

-----Original Message-----
Wider/skinnier refers to Column.

Taller/shorter refers to Row.

Try Format>Column>Autofit.

Gord Dibben Excel MVP



.
Click to expand...
 
G

Gord Dibben

Are any of the cells "merged"?

Row Autofit doesn't work properly with merged cells.

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

If not merged, did you recently manually re-size the row(s)?

This can screw up Autofit. Select all rows and Format>Rows>Autofit again.

Is wrap-text enabled?

Gord Dibben Excel MVP
 
G

Guest

Thank you for your response. The cells are not merged and
I have not manually resized them, wrap text is enabled.
After realizing none of this worked I did have to go in
and resize them manually, but I really appreciate the code
and link reference, I'll check them out. Thanks again.
 
Top