Double click the cell that contains the text you want to enter a new line on. The cell will highlight, you will also notice the mouse cursor turns into a flashing text cursor when hovering over the text.
In our example we can see a long string of text in the cell B3, we will double click this cell.
2. Click the part of the text where you want to enter the new line
Click the area of text where you want to enter down. You will see the flashing text cursor appear where you clicked.
We want to add the new line to this text between the words a and Google in our text. We click the area between the two words.
3. Press and hold the Ctrl key (Cmd ⌘ key on Mac) + Enter to insert a new line
While pressing and holding the Ctrl key (Cmd ⌘ key on Mac) press the Enter key. You will see a new line is entered into the text at the chosen area and the rest of the text is shifted below.
In the example the line has been entered after “…value in a” and the rest of the text now starts below in a new line.
4. Click outside of the cell or press Enter to see the results
With the new line added click outside of the cell or press the Enter key. The results will be displayed with the new line added.
In our example we can see the line has been added.