How does excel2010 protect the cell?

How does excel2010 protect the cell?

Open Excel 2010, select any cell, right-click, open menu, select Format Cells command

excel2010

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.

excel2010

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

excel2010

Switch to the Review tab, click the Protect Sheet button in the change group

excel2010

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

excel2010

When you try to edit a cell that is locked, the following prompt dialog box appears

excel2010

If you want to unlock, switch to the Review tab, and in the Change group, click the Undo Sheet Protection button