How to remove formulas from worksheet but keep the values/results in Excel? In some cases, you may need to remove formulas from worksheet and only keep the calculated results in cells. You can achieve this with the following methods in this article. Remove formulas from worksheet but keep results with pasting as value method In Excel ‘Go To Special’ is a very handy option when it comes to find the cells with formulas. ‘Go to Special’ option has a radio button “Formulas” and selecting this radio button enables it to select all the cells containing formulas. How To Add Numbers in Excel: The SUM Function Explained Written by co-founder Kasper Langmann, Microsoft Office Specialist.. Most people know that Excel is a spreadsheet application that allows for entry and storage of data. Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category. If you don't want the formulas hidden when the sheet is protected in the future, right-click the cells, and click Format Cells. On the Protection tab, clear the Hidden check box. Hiding and protecting formulas is currently not supported in Excel for the web.