Course contents · Import, templates, protection

Protecting cells, sheets and workbooks

Open the practice in the trainer →

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

  1. Select the input cells → Ctrl+1 → Protection tab → clear the Locked check box.
  2. 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.

Tasks in the trainer

  1. Change the rate in B3 to 15%.
  2. Change the term in B4 to 5 years and check that the formulas in B6:B7 recalculated.
  3. Increase the loan amount in B2 to 250,000.
  4. With 250,000 at 15%, find the term B4 that makes “Total to repay” (B7) = 400,000.
  5. With a 4-year term, find the rate B3 that makes the interest (B6) 100,000.

Solve the tasks in the trainer →

Check yourself

  1. You cleared “Locked” but did not protect the sheet. What happens?
  2. What does “Protect Workbook” prevent?