Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Have you tried Ctrl + enter? – Jacob Jan Tuinstra Jan 24 '13 at 7:21

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)

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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