I pressed return to make a new line in a cell of my Google Spreadsheet. That just moved the cursor to the next cell.

How does one add a new line in a cell?

When you're focused on the cell press enter to get into edit mode:

• Windows/Linux/Chrome OS: Ctrl + Enter
• Mac: Command/option(Alt) + Enter
• Linux: Ctr + Enter works – Philippe Blayo May 31 '13 at 18:45
• If you need a line break in a formula, use CHAR(10). – Curtis Blackwell Dec 9 '13 at 13:47
• This is so cool :) – Suresh Pattu Jan 29 '14 at 6:13
• On Windows AltGr + Enter works too – Tyblitz Oct 5 '15 at 21:38
• I just facepalmed! Why isn't this SHIFT+Enter, like so many other applications? – ecbrodie Aug 23 '18 at 16:41

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

• =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
• =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

In Edit Mode

• Windows/Linux: Ctrl + Enter or Alt + Enter

• Mac: Command/option(Alt) + Enter

• Here's another useful way to do it: =JOIN(Char(10), A1,A2,A3...) – Matan Dec 17 '17 at 22:59

protected by phwd♦Sep 19 '13 at 16:32

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).