Make cells automatically shrink to fit text in OpenOffice spreadsheet

Question

Is there a way to get the widths of cells to automatically shrink themselves to fit the longest line in a column?

Answer 1

Select the cells, then go to Format > Column > Optimal Width, then press OK.