In this article we will show you how to enter down in Google Sheets in just a few clicks. Simply follow the steps below:
When we have a lot of text in a cell it is often easier to break this text up by entering a new line. We can do this using the enter key.
For the purpose of this demonstration a sample sheet was created. Click here to access this sheet and follow along at home.
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.
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.
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.
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.
We hope this article has helped you and given you a better understanding of how to enter in Google Sheets. You might also like our articles on how to add a line break in Google Sheets and how to use the line break formula in Google Sheets.
To optimize your workflow, we recommend reading our guide on how to have Google Sheets send an email when a new row is added and trying our vacation tracker.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
