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?
Based on http://productforums.google.com/forum/#!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...
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.