>1. Highlight the column in question
>2. Home->Format->Autofit Column Width
>
>You can also double click the column header border.
>
>It seems like you have to do this after the text is changed.

This does not affect something in regards to this. Basically, if you enter "Inspection site" in your column header, shrink the column width until you see "on", the last two letters of the first word, to start appearing on the next line, then this is where I need to avoid that.