Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

In my professional life, I'm limited to use Microsoft Office. In Excel there is an option ows to render the result of a formula to be pasted as a "fixed value".

For instance A1 = "I",B1 = "ride", C1 = "a" and D1 = "bike"
In E1, I can place a formula to concatenate the values of A1 through D1 to display the sentence "I ride a bike", but if I should copy and paste that cell, I would just get the formula again, both if I write the formula with relative positioning, and if the values in A1:D1 change.
To solve this problem, Excel has "Paste Special > Value", which copies the current value of the cell to the target cell.

At home, I use LibreOffce.
Although I have tried to find a feature identical to "Paste Special > Value" in both LibreOffice and, I couldn't find it.
Does anyone know how to do this?

share|improve this question
Did you try using "paste special", unticking formulas and ticking numbers? – Mehper C. Palavuzlar Dec 29 '11 at 8:13
So why can't you leave it on #'s instead of UNTICKING everything and ticking numbers? Isn't that what we want to do? – user322501 May 13 '14 at 13:50

Just hit SHIFT+CTRL+V or Paste Special... from the Edit menu, unselect Paste all, and select Text or Numbers:

enter image description here

share|improve this answer
Thank you very much, Mehper ! – Rob Rijsdam Dec 29 '11 at 15:05
Good afternoon, Mehper, I have tried that one before, but it didn't work. Following your advice, I tried again and now it worked like a charm... So in all humbleness, it leaves me nothing but the conclusion that earlier I must have done something wrong:-) Thank you very much for your assistance and have a nice day ! Best regards, Rob – Rob Rijsdam Dec 29 '11 at 15:13
@RobRijsdam: Since the answer helped you, you should accept it. – surfasb Dec 30 '11 at 12:11
Still a lot of extra steps compared to Excel. Did M$ patent this feature or something? – neverfox Jun 25 '14 at 2:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .