How do I auto size cells?

I want Excel to resize cells, based on the content I put in them,
automatically.

Try AutoFit which you can find under Format > Row > AutoFit

"Aaron Mosby" wrote:

> I want Excel to resize cells, based on the content I put in them,
> automatically.

Either -
Click on the letter at the head of the column (to highlight the column)
Click on <Format><Column><Auto fit selection>

Or-
Click on the number to the left of the row (to highlight the row)
Click on <Format><Row><Auto fit selection>

As appropriate.

If this makes a column disproportionately large you could wrap the text in
selected cells. To do this -
Click on <Format><Cells><Alignment><Text><OK>

Regards.

Bill Ridgeway
Computer Solutions

"Aaron Mosby" <Aaron Mosby@discussions.microsoft.com> wrote in message
news:64BA17FE-2291-444A-98E9-2FE062A1CF95@microsoft.com...
>I want Excel to resize cells, based on the content I put in them,
> automatically.

Aaron

Look at Format>Row>Autofit and Format>Column>Autofit Selection.

If you have problems with the fitting perhaps you have another problem which
you haven't clearly stated.

Like....are any cells "merged"?..........how much text are you trying to enter
in a cell?...........are you set for "wrap text"?


Gord Dibben Excel MVP

On Mon, 12 Sep 2005 12:35:04 -0700, "Aaron Mosby" <Aaron
Mosby@discussions.microsoft.com> wrote:

>I want Excel to resize cells, based on the content I put in them,
>automatically.