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.

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.

How to Delete Functions in Excel. Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet. Most developers use Excel functions to automate ...

How to Protect and Hide Excel Macros. Creating a macro in Microsoft Excel allows you to program automatic tasks into a spreadsheet or template that can contain multiple commands or functions for ...

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.

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