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

Can you just 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

Your Answer


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