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.

You can hide formulas in Excel while working. All the formulas and the calculation work can be hidden from the viewers. Learn how to do it.

Protect and hide formulas At the cell level, it’s easy to both protect and hide formulas using simple formats–albeit not a format in the traditional sense.

As you can see, this technique can hide all sorts of sensitive information in a spreadsheet—yet keep it available when needed in the same location. However, if you want to be sure a user can’t peek at ...

You can also hide and protect formulas in the worksheet to prevent them from being accidentally modified or deleted by the user.

How to display or hide the formula bar in Excel? Open your spreadsheet and click on the File menu. Next, click on Excel Options and move to the Advanced tab. Scroll to the Display section. Uncheck the ...

However, there are also ways of hiding zero values by using formulas, but this is more complicated than using the feature. In order to hide zero values in your Excel spreadsheet, click File on the ...