Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2022-10-03 11:00:20 | ![]() 2,621 Views |
Reddit question posted: How do I lock specific cells in a worksheet that I don’t want edited at all?
https://www.reddit.com/r/excel/comments/xs3e8f/comment/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
Please take the opportunity to connect and share this video with your friends and family if you find it useful.