Answer: Click Format in the Cells group under the Home tab. Simply select AutoFit Column Width under Cell Size.
Explanation: Note: Click the Select All button, then double-click any boundary between two column headings to quickly autofit all columns on the worksheet.