How do I auto size cells?

A

Aaron Mosby

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

Bill Ridgeway

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
 
G

Gord Dibben

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
 

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

Similar Threads

Place picture in Excel cell 0
Table Header Cells keep shifting 8
How can the font and size of (all) citation numbers be altered? 1
Auto populate value from one task to another in MS PROJECT 0
Paste to excel from word - auto format problem 1
Automatic indexing in footnotes - solved 0
Word macro that can call cells out of Excel for a find and replace 0
HELP! macro for reseting size of comment with no text 0

Top