How to Change a Column’s Width in Excel - dummies

How to Change a Column’s Width in Excel

By Faithe Wempen

In Excel 2013, when content overruns a cell’s width, different results occur depending on the type of data and whether the cell’s column width has been adjusted manually.

In the following exercise, you adjust row heights in a variety of ways.

  1. In the spreadsheet, double-click the divider between the headers for columns A and B.

    Column A widens enough that the title in cell A1 fits in the cell, as shown in Figure 7-3. Although that looks okay, it’s not optimal, because column A appears too wide for the other data in the column.


  2. Click and drag the divider between columns A and B headers to the left so that the content of cell A7 fits in the cell with a few characters of space to spare.

    The content of cell A1 hangs off into cells B1 and C1, but that’s okay because they’re empty.

  3. Click the column header for column B to select that column and then choose Home→Format→AutoFit Column Width.

    Column B’s width increases to accommodate the longest entry (in cell B6).

  4. Click the column header for column C to select it and then choose Home→Format→Column Width.

    The Column Width dialog box opens.

  5. Type 12 in the dialog box, as shown, and then click OK.

    The column width changes to exactly 12 characters.


    This figure shows the worksheet after the column-width adjustments.


  6. Save the changes to the workbook and close it.