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.