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

  • 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
  • 2
    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. – Kartick Vaddadi 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.


I am doing a double step approach: I am copying from Google Sheets to Excel, then back to Google Sheets. 'Paste special' in Google Sheets transfers that information 2 times or 3 times & in a weird way! I hope it will be fixed soon.


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.

  • 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