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?thre...%40tkmsftngp05

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 FormatRowsAutofit again.

Is wrap-text enabled?

Gord Dibben Excel MVP

On Wed, 30 Jun 2004 16:47:00 -0700,
wrote:

So sorry, I meant taller, thank you


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

Taller/shorter refers to Row.

Try FormatColumnAutofit.

Gord Dibben Excel MVP

On Tue, 29 Jun 2004 16:20:43 -0700,

wrote:

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?

.