当前位置：网站首页>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 .
Insert picture description here
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 .
Insert picture description here
It can be found that the above red box has been locked , Cannot edit .
Insert picture description here
Protection can also be revoked .
Insert picture description here
You can try other functions and .

版权声明
本文为[YuanYWRS]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220557057765.html

边栏推荐

猜你喜欢

随机推荐