Choose Format/Cells/Alignment. Check the Wrap Text checkbox.

In article ,
j2t2011 wrote:

I want to create a spreedsheet that allows text to stay in one cell without
writing over to other cells..like instead of making the cell longer, I'd like
the cell to get thicker and have more than one line of text in the cell. Can
someone please ofer some help? Thanks.