How does one insert a new line in a cell in a Google doc spreadsheet? [duplicate]

Question

I saw a question with this earlier but nobody seems to have it answered in a way that helps me.

I need to paste text into a Google Docs spreadsheet cell but it needs to have two new lines in it. Whenever I paste it in, it puts the two new lines in three different cells. If I paste it into the one cell by going into the mode to edit that cell, the cell just shows up blank, as it does when I press Command/Alt+Enter to create a new line. Having any more than one line of text in a Google docs spreadsheet seems to be making a cell show up blank.

How do I fix this and get multiple lines?

Answer 1

What are you using to paste the text?

I did the following:

1. In Notepad, I created some dummy text with newlines in it

This is some test text


with newlines

2. I copied it from Notepad (Ctrl+C)

3. In a Google Spreadsheet, I selected a cell and pressed F2 to enter edit mode

4. I pasted the text (Ctrl+V) in the cell and pressed Enter

The text appears in the cell with the newlines included.

Further, I edited some other cells, and both Ctrl+Enter and Alt+Enter added newlines.

(Windows 7, Firefox 17.0)

Answer 2

If you enter the text by just clicking on the cell and pasting, it will put it in 3 different cells, just as you have described.

If you enter the text by clicking on the cell and then clicking on the editing line (top of the worksheet to the right of the "fx") it will do as you expect. It puts all the text in the same cell.

Answer 3

Or a better option is just to press control enter and it doesn't make the browser close down and it doesn't make the browser huge. It simply just adds another line to the cell allowing you to put more than one line in a cell.