Forum Discussion
Need to Lock only certain cells (Excel)
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.
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