1. Auto wrap text.
In order to make text appear as multiline, right click the cell and choose Format cells.
A pop up box appears then select the "alignment" tab and select "wrap text".
2. Hit Alt+Enter you will move to the next line, but this way the text will not automatically wrap while you change the Column's width.