I have a spreadsheet with a number of formulas that need to be removed with the values left behind. I generally just use copy & paste-as-values, but I am working with a number of sheets with a number of tabs.
Is there a way of stripping formulas in bulk but leaving behind the values?
The end users want to be able to sort and filter their data without regard to the formulas. This question is very similar, but I would be open to using scripts or add-ons.