Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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