Lock Specific Cells in Excel

Lock Specific Cells in Excel

HomeOther ContentLock Specific Cells in Excel
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Tryit Learnit 3652022-10-03 11:00:20 Thumbnail
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.