Double clicking on the resizer or expanding/collapsing header nodes would automatically adjust the headers' width to fit its content.

This behavior is similar to what one would observe from using Excel.