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.

How do I hide formulas in Excel until data is entered? To hide formulas in Excel until the data is entered, you need to enable the Hidden option.

Q. When I circulate my statistical Excel worksheet to users outside my company, I need to protect the underlying confidential formulas but also keep the worksheet easy for users to enter their data.