Lock cells to protect them

Suppose that your boss wants you to protect an entire workbook, but also wants to be able to change a few cells after you enable protection on the workbook. Before you enabled password protection, you had unlocked some cells in the workbook. Now that your boss is done with the workbook, you can lock these cells.

Follow these steps to lock cells in a worksheet:

  1. Select the cells you want to lock.

  2. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.

  3. On the Protection tab, select the Locked check box, and then click OK to close the popup.

    NOTE: If you try these steps on a workbook or worksheet you haven't protected, you'll see the cells are already locked. This means that the cells are ready to be locked when you protect the workbook or worksheet.

  4. On the Review tab in the ribbon, in the Changes group, select either Protect Sheet or Protect Workbook, and then reapply protection. See Protect a worksheet or Protect a workbook.

    Tip: 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 remove protection, simply remove the password.

In addition to protecting workbooks and worksheets, you can also protect formulas.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Protect a worksheet

Protect a workbook

Display or hide formulas

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×