Pasting text with line breaks into Google Sheets populates multiple cells

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

1st line
2nd line

and then paste in into a Google Sheets cell, then it pastes ‘2nd line’ into the cell below.

What are the ways to avoid 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.

Attribution
Source : Link , Question Author : tog22 , Answer Author : Alex

Leave a Comment