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.


You can copy the cell values and when pasting:

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

enter image description here

| 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
  • 1
    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 '16 at 13:00
  • 2
    Ctrl+Shift+v will paste values only. – paulhauner May 1 '17 at 2:36

What I do is use the Paste Special command to paste into Google Sheets and then copy the newly pasted information to copy over to another spreadsheet or document. It adds a step but it is the only way I know to perform this action.

| improve this answer | |

Pasting data values is NOT possible if the source cells are equations. Pasting data values only works if the source is TEXT data values. It's a frustrating limitation in Google Sheets.

| improve this answer | |
  • Patently untrue. I do it all of the time. – ale Jan 4 '18 at 1:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy