Here's an example:
1. Open Windows Explorer
2. Click on View, Details to goto detailed mode
3. Double-click where the indent is between the Name column and Size column

Voila! Your column size automatically changes to the exact size of the largest length of text.