Protect an Excel Sheet While Leaving Selected Cells Editable

Excel worksheet protection works by marking cells as locked or unlocked and then enabling sheet protection. Cells are marked “Locked” by default, but that setting has no effect until the sheet is protected.

Allow editing only in selected cells

1. Select the cells users should be able to edit.
2. Press Ctrl+1, open the Protection tab and clear Locked.
3. Go to Review > Protect Sheet.
4. Choose the actions users may perform. Usually Select unlocked cells is enough for a simple input form.
5. Add a password only if your workflow requires it, and store it safely.

Test it

Click a formula or heading cell and confirm Excel blocks the edit. Then edit one of the intended input cells. If users need to sort or filter, enable only those specific protection options.

Important: worksheet protection is designed to prevent accidental editing; it is not a strong security boundary for confidential data.