How Excel tables protect parts of cells

The Excel cell protection setting steps are as follows:

Let's take a look at the following example, the "Sum" column is computed, so the data on this column does not need to be entered or modified directly. We can lock up this column:

Select any one of the cells, right-click, and select formatting cells.

Click on the Protection tab and we will find that the lock is selected by default. That is, by default, all cells are locked once the worksheet is locked.

So, we select all the cells (Ctrl + a), click Right, and select format cells. Then remove the lock check on the Protection tab.

Then select the cells that you want to protect, in this case the entire "Sum" column (because the column is automatically computed), and lock it on the hook.

Tip: For convenience, you can also just cancel the lock on the part of the cell you want to edit.

Now that we've set up which cells we need to lock, we can turn on the lock feature.

Click the Review tab to protect the workbook.

With all users who allow this worksheet to do the following, you can choose what users can do. Usually leave the default option, and then press OK.

Note: If you set the password here, you will need to enter the password when unlocking the lock. Passwords generally can not be set.

When we try to edit the data in the "Sum" column, a message pops up saying that the content cannot be edited.

Although this cell is locked, it does not affect its data update. For example, this is the "sum" column, we change the individual data (source data), the sum will be automatically calculated.

If you need to unlock, click to undo Sheet Protection on the Review tab.