#Quickly auto fit all the columns in your worksheet. This macro code will select all the cells in your worksheet and instantly auto-fit all the columns. Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub