Autofit

Another option is to autofit the row's height (or the column's width) to match its content. Autofitting eliminates empty space by matching the row height or column width to its tallest or longest cell entry.

In the following example, when you right-click a cell in column E, the current date and time are entered into that cell, and column E's width is autofitted[…]