-
Select the column(s) to change, go to Home and select Format in the Cells group.
-
Under Cell Size:
-
For fixed width, select Column Width and enter a value.
-
To automatically set width, select AutoFit column width.
-
-
Select OK.
Tip: To quickly change one column's width, point your mouse at the right boundary of the column heading. When the pointer changes to , click and drag to the width you want.
-
Select the column(s) to change, go to Home and select Format in the Cells group.
-
Under Cell Size:
-
For fixed width, select Column Width and enter a value.
-
To automatically set width, select AutoFit column width.
-
-
Select OK.
Tip: To quickly change one column's width, point your mouse at the right boundary of the column heading. When the pointer changes to , click and drag to the width you want.