PlayInfoBox

Home /Utilities /How to Lock Only Specific Cells in Excel

How to Lock Only Specific Cells in Excel

Protect your formulas from accidental edits while leaving only the input cells open.

  1. Select the cells that should stay editable

    Choose the cells you want other people to still be able to edit, even after protection is turned on.

  2. Open Format Cells β†’ Protection and unlock them

    Press Ctrl+1 to open Format Cells, go to the "Protection" tab, and uncheck "Locked."

  3. Go to Review β†’ Protect Sheet

    On the Review tab, click "Protect Sheet."

  4. Set a password and confirm

    Enter a password and click OK β€” the entire sheet is now protected, except for the cells you unlocked.

  5. Why this matters

    You can protect cells containing formulas from being accidentally deleted while still leaving input cells open, keeping the layout safe.

Protect the formulas, leave the input open

In a shared template, protecting the whole sheet is easy β€” but the real skill is unlocking just the handful of cells people actually need to fill in first, then protecting everything else, so a stray keystroke can never wipe out a formula.

How this differs from workbook protection

Sheet protection controls what can be edited within a single sheet, while workbook protection controls the structure of the file itself β€” whether sheets can be added, deleted, renamed, or reordered. Use sheet protection for guarding cell content, and workbook protection when you need to lock down the file's overall layout.

Frequently Asked Questions

Are all cells locked by default?

Yes β€” every cell in Excel has the "Locked" property turned on by default, but it only takes effect once you actually apply sheet protection.

How do I remove protection later?

Go to the Review tab, click "Unprotect Sheet," and enter the password you set to remove the protection.