Home  >  Article  >  Software Tutorial  >  How to set a locked formula in Excel but make the content editable

How to set a locked formula in Excel but make the content editable

PHPz
PHPzOriginal
2024-08-29 11:03:29822browse

When we use Excel tables, we use formulas to calculate a lot of content. Many users want to set the formulas to be locked but the content editable, but they don’t know how to do it. To solve this problem, today’s software This tutorial will share with you the solution setting steps. Next, let us take a look at the detailed operation content. The tutorial is as follows: 1. Open the excel table that needs to be set, select the upper left corner of the table, click all to select the table, and click the locked cell under Review on the toolbar to unlock it.

Excel怎么设置锁死公式但内容可编辑

2. Then select the total score column, click Lock Cell, and then click Protect Worksheet.

Excel怎么设置锁死公式但内容可编辑

3. A dialog box to protect the worksheet will pop up. Enter the password and click OK. A pop-up will pop up to confirm the password again. Click OK.

Excel怎么设置锁死公式但内容可编辑

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

Excel怎么设置锁死公式但内容可编辑

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

Excel怎么设置锁死公式但内容可编辑

The above is the detailed content of How to set a locked formula in Excel but make the content editable. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn