Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

If I copy text with a line break in it, like this...

1st line
2nd line

...and then paste in into a Google Docs spreadsheet cell, then it pastes '2nd line' into the cell below. What are the easiest ways to avoid this?

share|improve this question

4 Answers 4

up vote 7 down vote accepted

Based on!category-topic/docs/formatting/-uEh3jguVu0 you can " copy the info single cell by single cell and paste the information in edit mode of the receiving cell; i,e. double-click the cell first before you paste the single cell contents". Though this is hardly 'easy' so there may be a better answer out there...

share|improve this answer

Select the cell you wish to paste into, then press F2 and it will allow you to paste the text in without separating the line breaks into their own cells.

share|improve this answer

This drove me crazy until I accidentally got my list to paste properly.

You have to double or triple click in the target cell so that the cursor appears. Then you can paste a list with line breaks into a cell in a Google spreadsheet.

I realize this was asked a year ago but my first search brought me to this post so I thought I'd share.

share|improve this answer
Isn't this essentially what the other answer says? – Al E. Jun 4 '13 at 19:02

You can quote the multiple-line contents with " now.

The quotation makes the pasting of a list of multiple-line contents so easy.

share|improve this answer
And what if the data already contains quotes? This is ridiculous. The cell contents should be preserved with line breaks. It is simply incorrectly functioning. Google Sheets is assuming some kind of text/CSV format for pasted cells, when in reality it should be honoring the source format. This also poses a problem for copying/pasting cells that are supposed to have quotes around them... Google Sheets unexpectedly strips off the quotes. It's absolutely incorrectly functioning and it needs fixed as of Apr 10, 2015. – Triynko Apr 10 at 19:34
thanks! works perfect when pasting some csv(tabbed) lines with multi-line text in one column – Ivan Ferrer Villa Sep 10 at 17:06

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.