Forum Discussion
Lock cell without protecting worksheet
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.
You wrote in the Wrong Message and Wrong Person. As far as I can see, I've been writing to another person. If you have any problem with any answer or with myself, you can send me a private message and I will answer you for sure.
NikolinoDE My apologies. Absolutely no problem. First time user here so it was my mistake.
No problem, whenever you have questions about Excel,
I am at your disposal.
By the way Welcome :)), if you will allow me, here is a link where you can get some information about this forum Welcome to your Excel discussion space!
...and how you can best ask questions to get a highly effective solution.
I wish you much success with Excel.
Nikolino
I know I don't know anything (Socrates)