Multiple paragraphs into Excel

When you paste text from another application—say, Word or Outlook, or your Web browser—into Excel, the spreadsheet breaks multiple paragraphs into multiple cells, even if that means overwriting existing data in the cells beneath the target. To force Excel to place all the copied text into one cell, just press F2 before pasting (or double-click in the cell), and all the text will remain together.