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 '20 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. – Through The Wonders Mar 18 '20 at 16:35
  • Found a way to make it works. – pjmg Mar 18 '20 at 16:42

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. – Through The Wonders Mar 18 '20 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. – Through The Wonders Mar 18 '20 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.