Excel: Auto Resizing Cells Vertically

  • Thread starter Thread starter Pownall
  • Start date Start date
P

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
 
try this
Sub autofitcells()
With ActiveSheet.UsedRange
..Rows.AutoFit
..Columns.AutoFit
End With
End Sub
 
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
 
Back
Top