In this tutorial, you will learn how to go down to the next line in Excel and Google Sheets.
Go Down to the Next Line
Users often get confused in Excel when they need to go to a new row inside a cell. That’s because ENTER in Excel selects a cell one row below. Let’s look at how to go to the next line in a cell in the following example.
You want to move the text after the comma (“this is the second line”) to a new line in cell B2. To do this, (1) select the text cell and in the Formula Bar, (2) position the cursor where you want to split the text (after the comma), and press ALT + ENTER on the keyboard.
As a result, the text in cell B2 now starts on the next line. Note that the wrap text option is automatically turned on.
Go Down to the Next Line Using Wrap Text
Another option is to use wrap text. You need to ensure that the cell is width matches the length of what you want to keep on the first line. The wrap text option will fill as much text as the length of the cell allows and then go to the next line.
To do this, select the text cell and in the Ribbon, go to Home > Wrap Text.
The final result is the same as in the previous example: The text in B2 is split into two lines. If necessary, adjust the column width. In this example, the column should be wide enough so the comma is on the first line and narrow enough to push the second “this” to the next line.
When using the wrap text option, Excel will automatically adjust the row height, based on the number of lines in the cell.
Go Down to the Next Line in Google Sheets
In Google Sheets, ALT + ENTER works the same as in Excel, so we’ll show how to wrap the text in a cell. To achieve this, (1) select the text cell and in the Toolbar, (2) go to Text wrapping and (3) choose Wrap.
Now, the text in cell B2 is displayed in two lines, and the row height adjusts automatically to fit the text.