For most content, I like to have all the text visible, but I don’t want the column to be any wider than it needs to be.
Excel lets users auto-size columns (and rows) so that they’re just wide (or tall) enough to fit all their content.
The Excel shortcut for this useful feature is to double-click the right edge of the column header.