当前位置：网站首页>Excel protects worksheets and workbooks from damage

Excel protects worksheets and workbooks from damage

2022-04-23 04:45:00 【YuanYWRS】

Insert picture description here
We have a form here , We guarantee that customers are only allowed to fill in the content , Without changing the style and size of his existing content .

First select the content that will not be changed .
1： lookup .
2： location .
3： Numbers .
4： Text .
And then you can see , Row and column values are selected .

Insert picture description here
1： Review （ The group had better remember ）.
2： Protection worksheet .
3： Input password （ Allowed operation , You can check... According to the actual needs ）.
4： determine .

It can be found that the above red box has been locked , Cannot edit .
Insert picture description here
Protection can also be revoked .

You can try other functions and .