In Excel if you have a long entry in a cell the text automatically spans into multiple columns. Here’s how simple Excel 2007 makes the task of wrapping text in worksheet cells.
Select the cell(s) you you want to wrap. Click Home on the Ribbon and select Wrap Text.
That’s all there is to it! Excel will wrap the text in the cell and also increase the height of the cell row.