In addition to protecting workbooks and worksheets, you can also protect formulas. If you want to lock cells or protect specific areas in Excel for the web, select Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet.. How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
You can lock cells in Excel if you want to protect cells from being edited. By default, all cells are locked. However, locking cells has no effect until you protect the sheet.. Learn how to protect specific cells in Excel using built-in features, formulas & VBA to secure your data while allowing edits where needed.