Move the mouse pointer over one side of the column header, and click and drag to the desired width. The column size displays in the Name box.
Release the mouse pointer and the column is resized. To resize multiple columns simultaneously, select the columns you want to alter.
Click and drag one of the selected column's header edges to the desired width and release it.
All the selected columns are resized to the same width.
INTRODUCTION
Sometimes data is too wide to be displayed within a cell, particularly if you just applied formatting to it. Excel provides several ways to remedy this problem. You can select columns and specify a width, or you can force Excel to automatically adjust the width of a cell to exactly fit its contents.
TIP
Specific Widths
To resize a column to an exact width, open the Format menu and select Column, Width. Enter the exact width in the dialog box that appears and click OK; the exact column width will be set. To automatically make an entire column (or multiple columns) fit the width of the widest cell in that column (or columns), open the Format menu and select Column, AutoFit Selection. Or, move the cursor over the right side of the column header and double-click when the cursor changes to a two-headed arrow.