Resize columns automatically?

The option is in the Folder Options and Edit Format dialogs. First checkbox in the first tab. (Display tab, Auto-size columns in Details and Power modes.)

If you have problems making it stick for all your folders, see the FAQ on understanding and configuring folder formats and shout if you're still having trouble.