Reddit question posted: How do I lock specific cells in a worksheet that I don't want edited at all?
/ iqi94xh
Step-by-step instructions:
1. Highlight/select the entire sheet.
2. Right-click anywhere then Click on "Format Cells" then Click on Protection tab then deselect Locked (clear it)
3. Right-click on the cells you want to lock then Click on "Format Cells" then Click on the Protection tab then Enable or insert check next to "Locked."
4. Protect sheet. You will only lock the cells you want to be protected.
#exceltips #lockcells #office365