Every Excel cell is marked Locked by default, but that setting does nothing until you turn on Protect Sheet. To make a form where only some cells are editable, unlock the input cells first, then protect the sheet.
Does this affect you?
Use this for Excel for Microsoft 365, Excel 2021, Excel 2019, Excel for Mac, and Excel for the web when formulas, headings, or important values should be protected while selected cells remain available for data entry.
Lock most cells but leave input cells editable
Use this for shared forms, templates, budgets, and trackers.
- Select the cells people should be allowed to edit. Hold Ctrl or Cmd to select separate ranges.
- Press Ctrl+1 on Windows or Cmd+1 on Mac to open Format Cells.
- Open the Protection tab.
- Clear Locked and click OK.
- Open the Review tab and click Protect Sheet.
- Optionally enter a password and store it safely.
- Choose which actions are allowed while protected, then click OK.
Now locked cells are protected, while the cells you unlocked remain editable. Test both a formula cell and an input cell before sharing the file.
Lock the entire sheet
Use this for a finished report or reference sheet where nobody should edit anything.
- Open the Review tab.
- Click Protect Sheet.
- Enter a password if you want to stop others from removing protection easily.
- Confirm the password if prompted.
- Click OK.
Because cells are locked by default, protecting the sheet without unlocking any cells makes the full sheet read-only.
More control
Unprotect a sheet
Use Review > Unprotect Sheet. If a password was set, you must enter it. Microsoft does not provide a normal recovery path for forgotten sheet-protection passwords.
Protect Sheet versus Protect Workbook
Protect Sheet controls editing inside one worksheet. Protect Workbook controls workbook structure, such as adding, deleting, hiding, renaming, or moving sheet tabs. Use both only when you need both protections.
Allow different users to edit different ranges
In Microsoft 365 business environments, Review > Allow Edit Ranges can assign specific editable areas to specific users while the rest of the sheet stays protected.
Fix cells that still will not edit
The usual cause is unlocking the wrong range or protecting before unlocking. Select the intended cells, confirm Locked is unchecked in Format Cells, then protect the sheet again.
Sources
- Microsoft Support – Lock or unlock specific areas of a protected worksheet (2025)
- Microsoft Support – Protect a worksheet (2025)
- Microsoft Support – Protect a workbook (2024)