Take the tour ×

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
Was the answer given, useful? –  Jacob Jan Tuinstra Jan 27 at 18:46
add comment

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


1 Answer

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 at 15:30
add comment

Your Answer

