How to adjust column automatically in excel.
open exel
1. go to sheet1
2.Right click and select VIEW CODE in menu
3. Select Worksheet from Top Menu
4. Write Code
Cells.EntireColumn.AutoFit
5.Close and now your columns are in autofit/adjust mode.