CODEWITHSUNDEEP
regexreplacegoogle-sheets
Amshumaan Rakshith
Amshumaan Rakshith

Reputation: 13

Keep all the formulas but delete all the values

How do I keep all the formulas but delete all the values in google script spreadsheet?
OR
How copy only the formulas from a sheet sheet onto another sheet?

Upvotes: 1

Views: 39

Answers (1)

pnuts
pnuts

Reputation: 59485

Copy your sheet, select all, and Find and Replace, Replace all within that sheet:

SO32161303 example

If you end up with 0s you don't want just do a straight Find 0, Replace all.

Upvotes: 2

Related Questions