简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Software Tutorial > Computer Software > body text

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

WBOY
Release： 2024-08-21 13:08:02
Original
616 people have browsed it

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.

Excel怎么锁住公式但可以编辑 excel保护公式数据可编辑方法

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

Excel怎么锁住公式但可以编辑 excel保护公式数据可编辑方法

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

Excel怎么锁住公式但可以编辑 excel保护公式数据可编辑方法

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

Excel怎么锁住公式但可以编辑 excel保护公式数据可编辑方法

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.

Excel怎么锁住公式但可以编辑 excel保护公式数据可编辑方法

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!

source：xpwin7.com
Previous article：How to turn off Microsoft Edge when it starts automatically at startup Tutorial on how to turn off Microsoft Edge when it starts up Next article：What is wpscloudsvr.exe? How to shut down wpscloudsvr.exe preventing shutdown?
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1521
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
1680
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1427
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1354
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1402
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！