You can auto fit the width of column by
- Double clicking on the column name on column header
- Double click on the cell pointer in worksheet
- Double clicking on column right border on column header
- Double clicking on the column left border of column header
