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.

By locking and hiding the formulas, you keep users from changing and viewing the formula. This is enough to keep well-meaning users from unintentionally damaging your work.

In Excel, the formula bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell.

The ability to lock cells or elements of Microsoft Excel and Google Sheets, but not the full sheet, allows maximum customization and control of a project.

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.

Excel table formulas driving you crazy? Learn the fix to lock column references, prevent errors, and simplify your spreadsheet calculations ...

To lock these numeric values, you need to delete the formula without deleting the calculated results. This is accomplished using Excel's copy and paste feature.