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.SelectCells.EntireColumn.AutoFitEnd Sub