Remove All Formulas From A Google Sheet, and Keep Values
Learn how to remove all formulas from a Google Sheet while keeping the values intact using simple copy and paste methods, including keyboard shortcuts.
So you want to remove all the formulas from a Google Sheet and keep the values . We have a sum here and we have an average, and we have a series of scores here. First thing you're going to do is copy. So we're going to select everything, right click, copy. And then in the same range , we can paste values only. That way the formulas go away. Another way you can do this with keyboard shortcuts is command C and then shift command V on a Mac. Google Sheet Basics - The Absolute Basics How To Hide Data with Checkboxes in Google Sheets Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas What is a spreadsheet formula?