Locking specific cells prevents other users from accidentally editing your formulas.
Locking Cells
- Press Ctrl + A to select all cells, right-click, and select Format Cells.
- Go to the Protection tab and uncheck “Locked”. Click OK.
- Highlight only the cells you want to protect, go back to Format Cells, and check “Locked”.
- Go to the Review tab and click Protect Sheet.