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.

Password-Protected Macros Open the Excel worksheet where you wish to place the macro and then activate the Visual Basic for Applications options by turning on the Developer tab.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.