• Fit the contents To make the column width fit the contents, double-click the boundary to the right of the column heading. To do the same for all columns on the worksheet, click the Select All button, and then double-click a boundary to the right of one of the column headings.
• Change multiple columns To change the column width for multiple columns, select the columns you want to change, and then drag a boundary to the right of a selected column heading. To change the column width for all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
• Manually change the width To manually change the width, select the column, point to Column on the Format menu, click Width, and then enter a number.
• Copy a width To copy the width of one column to another, select a cell in the column, click Copy on the Standard toolbar, and then select the target column. On the Edit menu, click Paste Special, and then click Column widths.