Forum Discussion
Lock cell without protecting worksheet
Hi all, Hope everyone is doing well there. I would like to seek advise from experts here on how to 'lock certain cells without protecting the worksheet.' Is it possible to do so? My compa...
Protect individual cells in Excel
1. Start Excel.
2. Switch to the “Check” tab and select “Remove sheet protection”. You may need to allow this with a password if the worksheet is locked.
3. Select all cells by clicking in the top left corner of the table.
4. In the “Start” tab, select “Format> Format cells> Protection” and uncheck “Locked”. Click OK".
5. Now select the cells that you want to protect and choose "Format> Format cells> Protection" again. Check the box next to "Locked" and confirm with "OK".
6. Finally switch to "Check" and select "Protect sheet".
Adjust the options in the list to suit your needs.
Lock or unlock specific areas of a protected worksheet
I wish you continued success with Excel (the coolest invention since chocola... uh ... Microsoft! :-)))
and…Please keep asking here - I just taught myself Excel with the help of this forum.
Hope I was able to help you with this info.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- I am pleased that you have received a suggested solution for your requirement.
If you found one of the suggested solutions helpful, please mark it as "Best answer" or / with a like. This will be of great benefit to other community members who read here.
Always welcome.
Wish you a nice day / night with a lot of health, joy and love.
Nikolino
I know I know nothing (Socrates)
