Click 'Wrap' (Button also looks like a curved arrow).

On the top toolbar, click the 'Text wrapping' menu / button (looks like a curved arrow).

Select the cell(s) that you want to wrap.

To wrap text in Google Sheets, follow these steps: There is a feature in Google Sheets that will make text go to a new line automatically when the text reaches the end of a cell, like when you type paragraphs in a word document and when the text reaches the end of the [age it goes to a new line automatically. When you do this, you will see the flashing cursor go from one line to the next, indicating which line you are about to type on.Īfter new lines are already inserted within the cell, you can use the up and down arrow keys to navigate from line to line. When the cell is being edited / is in edit mode, you can use the shortcut above to insert a new line in a cell. To edit a cell, you can double click on it, or you can click on the cell once and then press enter, or you can simply start typing after selecting a cell. Much like the 'Space' character it is invisible, but it is a 'character' all the same (like punctuation). Pressing Ctrl + Enter on the keyboard inputs the New Line (carriage return) character. The keyboard shortcut to insert a new line in a cell or a formula, is this (Use while editing the cell):

Repeat the steps to insert more lines within the formulaĬlick here to get your free Google Sheets cheat sheet Keyboard shortcut to insert new line in cells / formulas.

Type the next portion of the formula that you want to be on the second line.

Type the portion of the formula that you want to be on the first line within the cell.

To insert a new line within a formula in Google Sheets, follow these steps:

Repeat the steps to insert more lines within the cell.

Type the text that you want to be on the second line.

While the cell is still being edited, press Ctrl + Enter on the keyboard, and the cursor will go to a new line / a new line will be added within the same cell.

Type the text that you want to be on the first line within the cell.

To insert a new line within a cell in Google Sheets, follow these steps:

Excel for mac carriage return in cell