Quote:
Originally Posted by melvin1942
I am wanting to lock a cell. I asked for help and got an answer, I followed the direction that I got, but when I try to lock a cell it seems as though it did not work. I can still change what is in the cell. Do you have to protect the whole sheet for it to work?Melvin1942
|
Yes, you have to protect the sheet.
Quote:
Originally Posted by melvin1942
If I protect the sheet does this keep a person from entering anything in unprotected cells?
|
No user can change cells with Locked checked. Any user can change cells with Locked unchecked.
Quote:
Originally Posted by melvin1942
Can I lock a cell by itself?Melvin1942
|
07-13-2017, 09:39 AM
Similar Threads
format changes after locking cells
Windows 8 
Office 2016
Threaded Mode