Click Format in the Cells group on the Home tab. Click AutoFit Column Width under Cell Size. Note: Click the Select All button, then double-click any border between two column headings to fast autofit all columns in the spreadsheet.