Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I auto size cells?
I want Excel to resize cells, based on the content I put in them,
automatically. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 wrote in message ... I want Excel to resize cells, based on the content I put in them, automatically. |
#4
|
|||
|
|||
Aaron
Look at FormatRowAutofit and FormatColumnAutofit 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 wrote: I want Excel to resize cells, based on the content I put in them, automatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print view & print, in excel, different size cells | Excel Discussion (Misc queries) | |||
identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
Can you keep a cells BOLD Font, cell color size | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Auto fill in cells | Excel Worksheet Functions |