How to Change a Column’s Width in Excel
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.
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.
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.
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).
Click the column header for column C to select it and then choose Home→Format→Column Width.
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.
Save the changes to the workbook and close it.