How to lock Excel formula but make it editable? How to set editable locked formulas in Excel

For formulas in Excel tables, sometimes we need to lock the formula to prevent it from being modified by accidental operation, but we also want to be able to edit other content. In this case, we can use Excel's lock feature to achieve this purpose. Next, we will introduce how to set up how to lock formulas in Excel but still be able to edit them. You can easily set this up by following the steps below.

Introduction to locking Excel formulas but making them editable:

After opening the software, enter the table that needs to be set, select the entire table, then click the "Review" option on the toolbar, and then cancel the lock cell function.

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 Excel formula but make it editable? How to set editable locked formulas in Excel. For more information, please follow other related articles on the PHP Chinese website!