text wraparound

[Helena]

Is there a function that will automatically bump rows down to accomodate and fully display text as I add text to a cell? Rather than have continuing text become hidden at the end of a cell, can it all be fully displayed vertically, pushing down the entire row?

 

[Joe4]

Format | Cells | Alignment |

Then under Text Control, select Wrap Text