Select the column that you want to autofit. Click the Home tab and click the Format button in the Cells group. Click on the Autofit Column Width option. What is Wrap text tool in Excel? The Wrap ...

Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

Clicking "AutoFit Column Width" forces Excel to adjust the width of the columns you selected so that they are wide enough to display their contents. Every Excel spreadsheet has a "Select All" button.

From the drop-down list, select "Autofit Row Height." Click the "Format" button again and select "Autofit Column Width." Apply a design format to your table.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.