Excel cell protection lock function in which Excel2010 protects cell locking methods

Open Excel 2010, select any cell, right-click, and select "set cell format" from the shortcut menu.

Switch to the "protection" tab. Here we can see that the "lock" check box is checked by default, that is, once the worksheet is locked, all cells are locked.

Press Ctrl + A to select all cells, right-click "set cell format", switch to the "protection" tab, and check the small box before "lock, click OK to save the settings.

Select the cell to be protected and check the "lock" check box.