How to lock the formula in Excel but can edit it? How to protect the editable formula data in Excel

How to lock formulas in Excel but allow them to be edited? Recently, a user asked this question. Excel is an easy-to-use tabular data processing software with rich functions. Some formulas are used when using it. Is there a way to lock the formulas but still be able to edit them? In response to this problem, this article brings a detailed introduction to the method and shares it with everyone. Let’s take a look. How can Excel lock formulas but be able to edit them? 1. Enter the software, open the table that needs to be set, select all the tables, and click the lock cell function below the review on the upper toolbar to unlock it.

2. Then select the total score column, click Lock Cells in the menu bar above, and then click the Protect Worksheet function.

3. In the pop-up window, enter the password and click OK to save.

4. Then when we enter the English score, the total score will be automatically displayed due to the formula.

5. But if you want to modify the formula, a prompt dialog box will pop up, indicating that it is being protected and modification is not allowed.

The above is the detailed content of How to lock the formula in Excel but can edit it? How to protect the editable formula data in Excel. For more information, please follow other related articles on the PHP Chinese website!