AppGarden Calculation Sign-Off and Lock logo AppGarden

Calculation Sign-Off and Lock

Lock the formulas and leave the inputs open in Excel™

By Paul Kemp · Published

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.

  1. Select the input cells, the ones people should type in.
  2. Press Ctrl+1 to open Format Cells, go to the Protection tab and untick Locked.
  3. Shade the input cells so people can see which they are.
  4. Choose Review → Protect Sheet. Choose which actions are allowed, and set a password if you want one.
  5. Repeat for each sheet. Protection applies per sheet.
  6. Test it: try to type in a formula cell, then in an input cell.

Know the limits

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.