When you use Excel 2010, you want to lock certain cells to prevent others from tampering or accidentally deleting data. So how does this work? Please see below for specific steps:
Method/Step
Open Excel 2010, select any cell, right-click, open menu, select Format Cells command
Switch to the Protection tab, where we can see that the Lock check box is checked by default, which means that once the worksheet is locked, all cells are locked.
Press CTRL + A shortcut to select all cells, right-click Format cell, switch to the Protection tab, tick the small box in front of the lock, and click OK to save the settings
Then select the cells you want to protect, check the Lock checkbox
Switch to the Review tab, click the Protect Sheet button in the change group
The Protect Sheet dialog box pops up, and all users who allow this worksheet can choose which actions are allowed in the list box, and generally leave the default settings
Here we can also set unlock lock when prompted to enter a password, just remove the worksheet protection in the Password text box to type the set of password can be
When you try to edit a cell that is locked, the following prompt dialog box appears
If you want to unlock, switch to the Review tab, and in the Change group, click the Undo Sheet Protection button