If I select say 10 rows in Google Spreadsheets and use ctrl+c and then create a new spreadsheet and try to paste all the data it only moves over the values but not the formulas. Is there any way to paste all the data including the formulas? This feature works only if I paste it in the same spreadsheet. Thanks!

  • Have you tried right click > Paste special > Paste formula only
    – pjmg
    Mar 18, 2020 at 16:25
  • 1
    Yes, I have tried. This feature only works on the same page, if I open any other spreadsheet it doesn't. Mar 18, 2020 at 16:35
  • Found a way to make it works.
    – pjmg
    Mar 18, 2020 at 16:42

1 Answer 1


First you need to show formulas :

enter image description here

Then copy and paste values only.

  • Wow! That's awesome, it really works! Thank you, you are a lifesaver! I have no idea how you managed to come up with this idea. Mar 18, 2020 at 19:36
  • There's only one problem. Let's say one of the cells in a row has a formula =sum(B66,B64). Normally, if I copy and paste a row that contains such a formula, it automatically takes the coordinates of a new row and B66 and B64 become B1 and B2 or whatever. If I do the way you suggested, it doesn't. Mar 18, 2020 at 19:55

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.