Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 79 down vote accepted

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

  • Windows/Linux: Ctrl + Enter
  • Mac: Command/option(alt) + Enter
share|improve this answer
Thank you! That works reliably. – David Faux Apr 15 '12 at 3:12
Linux: Ctr + Enter works – Philippe Blayo May 31 '13 at 18:45
If you need a line break in a formula, use CHAR(10). – curtisblackwell 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


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 am added this for those that need this answer :)

New Line in Cell Formula...

  • Use the formula - CHAR(10)

Example Usage

=Concatenate("This is the first line", CHAR(10), "This is the second line")

Dez's Answer

Note: slight modification

In Edit Mode

  • Windows/Linux: ctrl + Enter or alt + Enter

  • Mac: Command/option(alt) + Enter

share|improve this answer

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.