Forum Discussion

adlbrk's avatar
adlbrk
Copper Contributor
Feb 05, 2024

"protect sheet" option still allows for deleting of protected cells

I protected the above worksheet under "protect sheet" option, inserted my password then "ok" but it still allows for deleting of protected cells. The only way around this is if I unselect "sele...
excel
Rodrigo_'s avatar
Rodrigo_
Steel Contributor
Feb 07, 2024

adlbrk 
Follow these steps:

  1. Unprotect the worksheet if it’s protected.
  2. Now, select the range (column C) that you want to lock.
  3. Open the Format Cells popup window (by pressing Ctrl+Shift+F or Ctrl+1). On the Protection tab, check the Locked box, then click OK.
  4. Finally, go back to the Review tab and select Protect Sheet.

reference>>> Lock or unlock specific areas of a protected worksheet - Microsoft Support

adlbrk's avatar
adlbrk
Copper Contributor
Feb 07, 2024

Rodrigo_thanks that worked!

 

But I can't lock certain cells. I highlighted the above columns and protected them but it protects the whole worksheet.

 

 

Resources