thats in vba, you can do it manually by selecting the "all sheets" button which is in the corner to the left of the column A heading and above the Row 1 label. This selects all the sheets, then double click the edge of one of the column headers it will autofit all columns on the sheet.