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?
Add a comment
|
2 Answers
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
answered Apr 5, 2012 at 2:08
-
3
-
35If you need a line break in a formula, use
CHAR(10). Commented Dec 9, 2013 at 13:47 -
1
-
What is the option for adding the new line from mobile application of google spread sheet? Commented Nov 24, 2017 at 10:13
-
7I just facepalmed! Why isn't this SHIFT+Enter, like so many other applications?– ecbrodieCommented Aug 23, 2018 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 :)
Dez's Answer
In Edit Mode
Windows/Linux: Ctrl + Enter or Alt + Enter
Mac: Command/option(Alt) + Enter
answered Feb 24, 2016 at 9:24
-
1Here's another useful way to do it:
=JOIN(Char(10), A1,A2,A3...)– MatanCommented Dec 17, 2017 at 22:59 -
=TEXTJOIN(CHAR(10), 1, "Line 1", "Line 2", "Line 3")may even be better to treat empty values Commented Nov 11, 2023 at 9:48