Need to Lock only certain cells (Excel)

Copper Contributor

How to lock certain cells only in Excel?  I am trying to store a partially locked Excel spreadsheet in One Drive and it is either all or nothing.

 

Thank you in advance.

1 Reply
Firstly, unlock all the cells in your worksheet by Pressing Ctrl + 1>>Protection>>Uncheck Locked option. Next press the Control key and select all the cells you want to lock. Press Ctrl+1>>Protection>>Locked(checkmark the box). This will Lock the selected cells. Now you can protect your worksheet from the review tab. This will lock your selected cells only