>>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?
>
>In its simplest form, you may simply put a text in a cell, such as "Inspection site". Then, diminish the width of the column until you see the word "Inspection" being cut. That is what I am trying to avoid.

Do you want the text to flow over to the next cell, if it's blank? Or do you want the column to stop resizing when you see the text being cut off?