Excel: Auto Resizing Cells Vertically

[Pownall]

I cannot figure out how to make the cells of an Excel spreadshee
automatically expand (resize) vertically to show the entire contents o
the cell. I know how to manually resize, but now how to get th
application to do it automatically.

I think that auto resizing is the normal default for Excel spreadshee
when you have the 'text wrap' on. However, I have received Exce
spreadsheet from other people, and it seems like I have invertantl
create spreadsheet that don't have automatically resizing cells. Ther
are too many cells to manually resize each one.

Thanks

 

[Don Guillett]

try this
Sub autofitcells()
With ActiveSheet.UsedRange
..Rows.AutoFit
..Columns.AutoFit
End With
End Sub

 

[TKT-Tang]

Mr. Don Guillett,

Please refer to the following query :-

http://groups.google.com/groups?hl=...en&lr=&ie=UTF-8&c2coff=1&q=tkt_tang+long+text

Thank you very much indeed in advance.

 

[Rob Graham]

Double click the bottom of the row (where they are numbered in the margin).
I suspect that if you click the Select All button at top left of the
workbook and then double click the bottom of a row it will autosize all the
rows, but I don't know for sure.

Rob Graham