PlayInfoBox

Home /Utilities /How to Protect a Worksheet in Excel

How to Protect a Worksheet in Excel

Tap through each step to lock down a worksheet without locking out the people who need to enter data.

  1. Select the cells you want to leave editable (optional)

    If only some cells should stay editable, select that range first, then go to Format Cells β†’ Protection and uncheck "Locked."

  2. Open the Review tab and click Protect Sheet

    Go to the Review tab and click "Protect Sheet" in the Protect group.

  3. Set a password (optional)

    Enter a password if you want one required to remove protection, or leave it blank if you do not need that.

  4. Choose which actions to still allow

    Check the boxes for anything you want users to keep doing, such as "Format cells" or "Sort," then click OK.

  5. Unprotecting it later

    Go back to Review β†’ Unprotect Sheet and enter the password if you set one, and the sheet is fully editable again.

Worried about formulas getting overwritten by mistake?

When a shared spreadsheet has formulas or a fixed layout that people keep accidentally typing over, sheet protection lets you restrict editing to only the cells meant for input, which cuts down on that kind of mistake without needing to babysit the file.

Locking only part of a sheet

Protection by default locks every cell. If you only want to protect a formula area while leaving an input area free, unlock that input range first (Format Cells β†’ Protection β†’ uncheck Locked) before turning on sheet protection β€” otherwise the whole sheet gets locked down.

Frequently Asked Questions

What happens if I forget the password?

There is no official recovery method for a forgotten worksheet protection password, so make sure to save any password you set somewhere safe.

Is this the same as locking the whole file?

No. Sheet protection only restricts editing inside that worksheet. To require a password just to open the file at all, use a separate "encrypt with password" option instead.