Posted in Uncategorized

Excel: Paste multi-line text into a cell

If you copy and paste multi-line text into a Excel cell, Excel pastes into multi-row or multi-column data. This blog tip is to show how to paste a text into a cell and preserve the tabs and paragraphs into the same cell.


1. Copy your multi-line text (Control-C)

2. On Excel, Select the cell and click on Formula bar and paste text. OR Select the cell, press F2 and paste the text. 


Hope it helped you. Enjoy Smile


Being in Silicon Valley for years, I became a IT Infrastructure Geek by experience and surrounded by other Geeks everywhere. I try to help others by the solutions I found on odd occasions.

2 thoughts on “Excel: Paste multi-line text into a cell

  1. Hi. I really enjoyed my brief visit on your site and I’ll be sure to be back for more.
    Can I contact your through your email?

    Please email me back.


  2. When I originally left a comment I seem to
    have clicked the -Notify me when new comments are
    added- checkbox and from now on every time a comment is
    added I recieve 4 emails with the exact same comment.
    Perhaps there is a way you are able to remove me from
    that service? Many thanks!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s