Forum Discussion
BrendaMBTA1991
Aug 06, 2021Copper Contributor
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.
nidhiachhaa9
Aug 06, 2021Brass Contributor
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