Under Format in the top bar, there should be a button called AutoFormat. Although it's not truly automatic, it adjusts the width of columns based on the amount of text in the individual boxes.
You could format cells to auto wrap text which should extend the cell height automatically to display all the entered text, but you will still need to adjust the width.
You can set the cell width to adjust automatically under the options menu. It is a fairly simple process once you have located the option within the program. Once located simply enable this feature.
