127

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?

151

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
  • 2
    Linux: Ctr + Enter works – Philippe Blayo May 31 '13 at 18:45
  • 24
    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
  • 1
    On Windows AltGr + Enter works too – Tyblitz Oct 5 '15 at 21:38
  • 4
    I just facepalmed! Why isn't this SHIFT+Enter, like so many other applications? – ecbrodie Aug 23 '18 at 16:41
32

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 :)

Dez's Answer

In Edit Mode

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

  • Mac: Command/option(Alt) + Enter

  • 1
    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).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.