Web Applications Stack Exchange is a question and answer site for power users of web applications. 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

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the sheet.

I need the copy to only carry through values and not references.

share|improve this question

migrated from superuser.com Oct 15 '12 at 16:49

This question came from our site for computer enthusiasts and power users.

Was the answer given, useful? – Jacob Jan Tuinstra Jan 27 '13 at 18:46

You can copy the cell values and when pasting:

  1. Right-click
  2. Paste Special...
  3. Paste values only

enter image description here

share|improve this answer
Awesome, this was exactly what I was looking to find out, and the added image makes it crystal clear. Thanks. – Kzqai May 13 '13 at 15:30
This doesn't work if you want to paste the value in another spreadsheet or in email, etc. Is there a solution to that problem? Note that I don't want to copy the displayed number, since it's rounded. I want to copy the actual result of the formula. – Vaddadi Kartick Mar 31 at 13:00

Your Answer


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