You can auto fit the width of column by

Select one:
A. Double click on the cell pointer in worksheet
D. Double clicking on the column left border of column header
C. Double clicking on the column name on column header
D. Double clicking on column right border on column header

D. Double clicking on column right border on column header