Lock the formulas and leave the inputs open in Excel™
You send a calculation workbook to colleagues. You want them to change the inputs and nothing else. By default every cell in an Excel™ sheet is "locked", but that only matters once the sheet is protected. So you unlock the inputs, then protect the sheet.
By hand
These steps apply to Excel™ in Microsoft 365. Work on a copy.
- Select the input cells, the ones people should type in.
- Press Ctrl+1 to open Format Cells, go to the Protection tab and untick Locked.
- Shade the input cells so people can see which they are.
- Choose Review → Protect Sheet. Choose which actions are allowed, and set a password if you want one.
- Repeat for each sheet. Protection applies per sheet.
- Test it: try to type in a formula cell, then in an input cell.
Know the limits
- Excel™ sheet protection can be removed quickly, so treat it as a guard against accidents, not against a determined person.
- A protected sheet blocks sorting on locked cells. If people need to sort, give them a separate view.
- Protection does not record who changed what, or whether the logic is still the one that was reviewed.
- Hidden or very hidden sheets still need thought: someone may unhide a sheet.
Lock and record together
Calculation Sign-Off and Lock's "Protect the calculation" locks all cells except the inputs and turns on sheet protection in one step, and works alongside the signed record that Verify checks later. Verify is free; locking with inputs open is a paid feature. The add-in runs inside Excel™ and does not upload your workbook.
See Calculation Sign-Off and Lock for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Calculation Sign-Off and Lock is made by App Garden and is not affiliated with or endorsed by Microsoft.