To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want.

To change column(s) to adjust the width automatically based on the contents, select the column or columns that you want to change. From the HOME tab, click FORMAT from the CELLS group. Click AUTOFIT COLUMN WIDTH under CELL SIZE.