If you’ve ever tried to paste text with line breaks into an Excel worksheet and wanted to pull your hair, this tip is for you. And if you’ve never needed to do this, consider this a preventative hair-pulling intervention.
When you paste text from web pages, emails, word documents containing multiple paragraphs into Excel each paragraph will go into a cell/row of it’s own.
Often you want all the paragraphs to go into a single cell instead. The solution is super simple. All you need to do is put the cell into edit mode by double-clicking in the cell or pressing your F2 key. You’ll know you’re in edit mode when you see a cursor blinking in the cell. If you paste your text now, it will all go neatly into a single cell just the way you want.