Protection reduces the risk of accidentally breaking formulas. By default all cells are locked, but locking only takes effect once the sheet is protected.
Protecting individual cells
- Select the input cells → Ctrl+1 → Protection tab → clear the Locked check box.
- Review → Protect Sheet, optionally with a password.
Now only the unlocked cells can be changed, and the formulas are safe.
Protecting a workbook
Review → Protect Workbook prevents adding, deleting, renaming and hiding sheets. A password to open the file is set in File → Info → Protect Workbook → Encrypt with Password.
Sharing
Modern Excel supports co-authoring files in OneDrive/SharePoint; older versions used the “Share Workbook” feature.
The sheet in the trainer below is protected: only the yellow cells B2:B4 are unlocked. Try changing a formula — Excel won't allow it.