When accessing a spreadsheet in Google Drive on a computer with a keyboard, I can enter a new line in a single cell by pressing alt+enter.

My keyboard on my Android doesn't even have an alt key.

How do I enter a new line on my Android device?

For a keyboard on my Android, I'm currently using Swype, but I am assuming, and hoping, there is some kind of general approach that is not specific to a particular keyboard.

  • 2
    I'm afraid there is no "general approach" for that. You might want to take a look into my list on Keyboards & Input Methods, which holds several candidates like Hackers Keyboard which support such "additional keys".
    – Izzy
    Sep 12, 2014 at 9:53
  • Idea #1 to try: create a "reference document" with a single cell where you put in the "new line" character in the cell on a PC and then use copy and paste on your Android device. Idea #2: does Google sheets support macros?
    – Gdalya
    Sep 18, 2014 at 17:35
  • PERFECT ANSWER, RIGHT HERE GUYS: webapps.stackexchange.com/questions/25359/…
    – user110230
    May 27, 2015 at 1:05
  • @user110230, that answer only applies to desktop computers, not to Android phones.
    – Questioner
    May 27, 2015 at 6:24

8 Answers 8


Easiest way: add an extra letter at the end of the line. Select that letter. Hit enter. The letter will be replaced with a new line.

  • 3
    This is the only right answer May 4, 2017 at 21:08
  • 1
    It has some important caveats: 1) It doesn't work with physical (bluetooth) keyboards, at leasst for me 2) it really needs to be a letter. If you select a space, it doesn't work.
    – Cheetah
    Feb 9, 2018 at 2:14
  • It works with Google Pinyin, but does not work with Google Japanese keyboard
    – fefe
    Jun 23, 2019 at 6:51
  • 4
    It doesn't work in the Google Spreadsheet app (didn't try on the webapp) Sep 22, 2019 at 21:31

The function CHAR(10) will return a Line Feed.

Combining with functions like CONCATENATE() or & will give a new line. Example:

=CONCATENATE("First line"; CHAR(10); "Second line")
="First line"&CHAR(10)&"Second line"

The only way that I found so far is through the clipboard.

Using a source document with a line break, with some effort you could succeed in selecting just the line break, and then copy/paste it.

Even easier is to use an app such as "Unicode Pad" or "Unicode CharMap", both of which will find and then copy/paste any character. You'll need to look for LF, LINE FEED or U+000A.
Note that you won't "see" the character after you select it, it shows as a space for obvious reasons.
This still isn't as convenient as I would like it to be, but at least I found it to work reliably.


The highlight a throw-away character and hit enter trick, as well as the type everything into a text editor, then copy/paste it into the Google Sheets cell, both only work on Android devices. I have a Google Spreadsheet that I'm sharing with a client who has an iPhone, and she needs to be able to enter multiple lines within a cell. So I came up with just a little Google Apps Script code to do it on her iPhone (can be entered into the drop-down menu of the Google Spreadsheet, Tools >> Script editor):

function onEdit(e) {
    e.range.setValue(e.value.replace(/\\\\/g, '\\').replace(/ *\\n */g, '\n').replace(/\/g, '\\'));

Basically, that creates a function (that is automatically linked to a Google Sheets trigger), and will run every time a cell is edited. It simply replaces all of the "\n" characters in your text with a line-break. Make sure that's a backslash, and not a normal slash. For programmers, the "\n" is a special character that represents a carriage return within a string. The only possible exception where an accidental line-break might happen would be when trying to input a Windows path into a cell such as "C:\Users\John\Documents\news". So double-backslashes is the common workaround for Windows paths among programmers. So one could enter "C:\Users\John\Documents\news" or even just simply "C:\Users\John\Documents\news" (since \n is really the only string we're replacing at this point).

It's also possible to change the replacement characters, in case anyone is more familiar with HTML:

function onEdit(e) {
    e.range.setValue(e.value.replace(/ *<br *\/*> */ig, '\n'));

Since "<br>" is much more deliberate (people don't accidentally type that in unless they want a line-break), it makes for a simpler replace function, since we don't have to do an escape for double-backslashes. But personally, typing in the angled brackets from an Android touchscreen keyboard are a bit inconvenient to do so twice for every line-break...


  • Nice, I think this is by far the most convenient way! I used myself just " lb " (as in line break) to be the value to be replaced with the newline so I can just write "line 1 lb line 2" and don't even need to go to special characters :)
    – Hemaolle
    Aug 14, 2020 at 8:44

Mark the cell in which you want to have new lines.

At the top menu click the "A" next to the redo button.

Select submenu

in the lower screen section a modal pops up. There hit the tab "CELL".

Than activate "Wrap Text".

Cell + Wrap Text

Now this cell will do line-breaks on long text.

  • 1
    Wrapping is not the same as an inserted line break.
    – wbogacz
    Mar 14, 2017 at 12:23
  • wbogacz is correct that this isn't a line break, but this is exactly what I was looking for.
    – Tom Wyllie
    Apr 30, 2018 at 14:11

The following trick worked for me: Ctrl + Enter

  • 6
    Mind to explain where Android devices have the Ctrl key? Note this site is about Android, not Desktop.
    – Izzy
    Oct 4, 2018 at 13:14
  • I assume (but haven't tested) that this might work on 3rd-party keyboard apps that have Ctrl key like Hacker's Keyboard.
    – Andrew T.
    Oct 8, 2019 at 7:09

I have succeeded by pressing several times Enter when typing a message, select all, copy it and paste it into a cell in a sheet.


Just select a line and press + (top right on the tool bar), you'll be offered to insert a row above or below or a link.

  • 1
    Note that the OP wants to insert a new line inside a cell, or probably should be called as line break instead... but not a new row.
    – Andrew T.
    May 14, 2015 at 6:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .