>>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.

I suspect that what you mean with header isn't the same as I mean with a header (typically row 1). And I think neither of us means the same as the people behind Excel mean. May I ask you to attach a picture, so that we talk the same language?