Lock cells to protect them
- Select the cells you want to lock.
- Click Home, then click the Format Cell dialog box launcher (the arrow to the right of Alignment in the ribbon).
- Click the Protection tab, select the Locked check-box, and then click OK.
- Click Review > Protect Sheet or Protect Workbook and reapply protection. Notes
- If you try these steps on a workbook or worksheet you haven’t protected, you’ll see the cells are already locked. That may not make sense at first, but what it means is the cells are ready to be locked when you protect the workbook or worksheet.
- It’s a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also unlock them after you apply protection. To do that, you remove protection by removing the password.
- In addition to protecting workbooks and worksheets, you can also and protect formulas.