Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Crisis averted–kind of. Permission to copy the entire workbook is another problem. For instance, if you open a protected Excel file in the browser edition, you can see hidden formulas.

There are mainly two ways to remove the formula in Excel and keep the text. No matter how many formulas you have used in your spreadsheet, you can delete or hide them without removing the values.

At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.