How does Excel implement partial cell protection?

How does Excel implement partial cell protection?

1, a lot of netizens do some protection, select the range of data you want to protect, and then select Worksheet Protection, enter the password, and find that all the cells are protected, because you are currently locking the entire cell, not the part of the area you chose, which is the main reason.

2, we pass a sum function example, to explain how to achieve the partial protection of Excel, first of all, let's take a look.

3, we click on the top left corner of the selection, or directly Ctrl + A, select the entire table, and then right, select "Set cell style."

4, select "Protection" and then uncheck the lock item. In this way, we cancel the entire table lock.

5, then we select "Edit"---"positioning" to locate the cell with the formula.

6, we choose "Formula", and then click "OK", these have the formula cell, is the area that we want to protect.

7, then we select "format"-"cell", and then the area to lock.

8, Next, we choose "Tools"-"protection" for protection editing.

9, the direct default option, after entering the password, OK.

10, we arbitrarily change the data of the A,b,c,d column, to see if the above changes on formula calculation has an impact, verify that no impact.

11, and then we verify that the area is protected, we click on the formula in the cell, found to be protected by the system, click on other formula-free cells, but also normal editing, to achieve the results we want.

12, finally, to tell you what this function most need to understand is that only when the worksheet is protected, locked cells and hidden formulas are valid. Then I generally understand that we have some of the cells locked, and then to protect, you can achieve partial protection, although this has no theoretical basis, but the pro test, or is available.