How does one add a new line in a cell in a Google doc spreadsheet?

Question

I pressed return to make a new line in a cell of my Google docs spreadsheet.

That just moved to the next cell. How does one add a new line in a cell in a Google doc spreadsheet?

Alex · Accepted Answer · 2012-06-01 11:45:07Z

up vote 10 down vote accepted

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

edited Jun 1 '12 at 11:45

Alex
13.1k42248

answered Apr 5 '12 at 2:08

Dez
3,633633

Thank you! That works reliably. – David Faux Apr 15 '12 at 3:12

user10950 · Answer 2 · 2012-04-05 01:45:55Z

up vote -1 down vote

Right click on the row number (left side) and select "insert 1 above" or "insert 1 below" as desired. Microsoft Excel works the same way.

answered Apr 5 '12 at 1:45

user10950
991

That's not what is being asked about. The Asker wants to know how to add a newline in a cell. – Al Everett Dec 15 '12 at 2:24

2 Answers