Separate text in 1 cell to 2 lines (or more)

Separate text in 1 cell to 2 lines (or more) can be a real headache for beginners.
Let me now show you the painkiller solution to this problem!

It is very simple, just press Alt+ENTER at the part you want to start a new line.

Separate text in 1 cell to 2 lines

There you go!


Above is my preferred way, you can also use Wrap text function to achieve that.

Wrap text

- Select the cell and press Wrap text.

Wrap text

And you will see the above.

- Next you will need to adjust the column width by dragging open the border of column A (refer to picture below).



 



 Lastly, you need to Autofit the row number 2 by double clicking the border below 2.






There you go!
Done!

Personally, I think the first method is better.
You may decide which is an easier method to employ :)