Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to paste some data into a spreadsheet, but since the data contains \n characters within it, the cells below are overwritten. I want to paste the entire bit of data into a single cell.


some \n
multiline \n

Needs to go into a single cell, rather than cells in 3 rows.

I'm interested in knowing how to do this for both LibreOffice and Excel.


share|improve this question
up vote 1 down vote accepted

Well for a single insert, I would just use F2 on the cell or enter it any other way, so you get the edit mode, then paste it.

Another way would be to use the formula-input at the top of the worksheets. Select your destiny cell, then select the formula-input, then paste.

Is is more complicated, when you have multiple multirow cells to insert.

share|improve this answer
F2 is exactly what I needed - thanks so much! – Eva Nov 1 '12 at 12:42
btw does this also work for excel? – Eva Nov 1 '12 at 12:42
funny, I don't use LibreOffice - so yeah, my answer was based on excel ;) – Jook Nov 1 '12 at 12:43
ah OK - works for both then :D – Eva Nov 1 '12 at 12:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.