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 show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.

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.

Thankfully, Excel makes it easy to hide or unhide rows and columns, allowing you to declutter your spreadsheet and focus on the information that matters most.

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 ...

Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.