Starting a new line in a cell is easy.
Let’s say you have this sentence:
Peter Piper picked a peck of pickled peppers. A peck of pickled peppers Peter Piper picked.
Now, you want to break the tongue twister above into two separate lines:
(1) Peter Piper picked a peck of pickled peppers.
(2) A peck of pickled peppers Peter Piper picked.
When in Excel, pressing ‘Enter’ (in the cell or in the formula bar) like how you would in Microsoft Word would only move the cursor to the next cell:
To start a new line, double-click the cell which contains the text. Then, click the place where you want to insert a line break.
In our example, the location would be between the dot (.) of the first sentence and the first letter of the second sentence:
Finally, enter a new line by pressing ‘Alt’ + ‘Enter’ on Windows or ‘Ctrl’ + ‘Option’ + ‘Return’ if you’re using Mac.