Wrap Text

The number of wrapped lines is dependent on the width of the column and the length of the cell contents.
This will increase the row height as more text is entered. If the row height is then set to a fixed height text will not split over to adjacent cells.

It is possible to make text wrap to multiple lines in a cell rather than appearing as one long line of text.

Now choose (Format > Cells)(Alignment tab, Wrap Text) check box, then click OK.
SS

Text entered into the selected cell automatically wraps to fit the cell. If you need to force a wrap at any given point, press Alt-Enter.

Allows you to wrap text in multiple lines with a cell. Wraps text into multiple lines in a cell. The number of wrapped lines is dependent on the width of the column and the length of the cell contents.
Text can be wrapped in a cell (Format > Cells) (Alignment tab, "Wrap text checkbox"). This will increase the row height as more text is entered. If the row height is then set to a fixed height text will not split over to adjacent cells.