Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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.