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 :)
