Excel hack to adjust column width according to content

Right Click Sheet1 and click on View Code

Select Worksheet from drop-down

Type Cells.EntireColumn.AutoFit and close VBA

Enjoy! You are good to go 🙂