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

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or simply a menu choice to paste values instead of the formulas, but this idea seems to be missing from Open Office, or called by some other name. Thanks for any help.

share|improve this question

Use Edit-->Copy then Edit-->Paste Special (or Copy and Paste Special... from the context (right-click) menu).

In the dialog uncheck paste all, check numbers and uncheck formulas.

This is in every version of OO/LO, that I've used.

share|improve this answer
Thank you! It was right under my nose. – toolman Feb 27 '13 at 14:20
This worked! Thanks. – Xonatron Feb 6 at 23:00

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.