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