19

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 '14 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 '14 at 17:35
  • PERFECT ANSWER, RIGHT HERE GUYS: webapps.stackexchange.com/questions/25359/… – user110230 May 27 '15 at 1:05
  • @user110230, that answer only applies to desktop computers, not to Android phones. – Questioner May 27 '15 at 6:24

10 Answers 10

16

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 – Carles Sala May 4 '17 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 '18 at 2:14
  • It works with Google Pinyin, but does not work with Google Japanese keyboard – fefe Jun 23 at 6:51
4

You can use the functions concatenate() and char(10) (carriage return). Example:

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

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.

2

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.

  • Wrapping is not the same as an inserted line break. – wbogacz Mar 14 '17 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 '18 at 14:11
0

Also, you can use CHAR(10) function in any free cell and then copy its content.

0

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.

0

Select a piece of text inside the cell and hit Enter. It will move cursor to a new line inside the cell.

0

Type a letter, select it and then press enter

0

The following trick worked for me: Ctrl + Enter

  • 4
    Mind to explain where Android devices have the Ctrl key? Note this site is about Android, not Desktop. – Izzy Oct 4 '18 at 13:14
-2

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.

  • 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 '15 at 6:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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