First: press CTRL + A => (choose all cells in a worksheet) => right click -> format cells -> Protection -> uncheck Locked and Hidden
Explore My Other Channel for More Cool and Valuable Insights
π Youtube Learn Tech Tipsπ Tiktok
π Facebook:And then, choose the cells which you want to lock cells, right click -> format cells -> Protection -> checked Locked
Open Menu Review -> Protect Sheet -> Checked "Select locked cells" and "Select unlocked cells" -> input password to protect your cells in a worksheet
Yeah, finished it!
When you try to update data in your lock cells range, you will get this message.
You can modify another range without lock cells
Thank you for reading this post. I hope you found it helpful and easy to follow. If you have any feedback or questions about
How to lock cells and protect cells in a worksheet Excel ,
please share them in the comments below. I would love to hear from you and discuss this topic further
✋✋✋✋
Webzone Tech Tips Zidane, all things tech tips web development
- I am Zidane, See you next time soon ✋✋✋✋