How do I set column widths to auto-size

Folder -> Folder Options -> Display -> Auto-size columns

See Folder Formats: Quick Guide if you want to make that the default for all folders.