See all How-To Articles

How to Go Down to the Next Line in Excel & Google Sheets

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 initial data

 

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.

 

go down to the next line initial data

 

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.

 

go down to the next line

 

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 2b

 

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.

 

go to next line wrap text 1

 

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.

 

go to the next line final

 

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.

 

google sheets text wrap

 

Now, the text in cell B2 is displayed in two lines, and the row height adjusts automatically to fit the text.

 

google sheets text wrap 2