Wouldn't it be nice to line up and autofit all the rows and columns in one click? Here's a quick macro that will allow you to do just that:
Selection.ColumnWidth = 255
Selection.ColumnWidth = 9
Cells.EntireColumn.AutoFit 'fit the columns
Basically, it selects all the cells, makes the column extremely wide, then autofits the rows and columns. The result is more like this:
Much better. Enjoy!