核心提示:excel表格怎么锁定单元格?一起看看吧! .
excel单元格锁定步骤如下:.
打开一个表格,按下“Ctrl+a”全选。.![](https://img.yupug.com/cccc/2019-12-19/235589b3218d0000985f3869227c6465.jpg)
02右键选择“设置单元格格式”。.![](https://img.yupug.com/cccc/2019-12-19/488a038942eca5f71b835c30b257e9bd.jpg)
03在弹出的对话框里选择“保护”。.![](https://img.yupug.com/cccc/2019-12-19/a67ebac68f998285b607938f2a01de44.jpg)
04将“锁定”前的钩去掉,点击“确定”。.![](https://img.yupug.com/cccc/2019-12-19/85586fbc3fff222c2753e5d2f5d11c3d.jpg)
05然后选定想要锁定的表格,同样右键,选择“设置单元格格式”。.![](https://img.yupug.com/cccc/2019-12-19/a67ebac68f998285b607938f2a01de44.jpg)
06在弹出的对话框中选择“保护”,勾选“锁定”之后确定。.![](https://img.yupug.com/cccc/2019-12-19/85586fbc3fff222c2753e5d2f5d11c3d.jpg)
07在上方的选项中点“审阅”,再点击“保护工作表”。.![](https://img.yupug.com/cccc/2019-12-19/af390f0ef5fbfdd8ecf6ecea07e93382.jpg)
08此事要输入锁定密码。.![](https://img.yupug.com/cccc/2019-12-19/58e2efce216b2c58b1ceaafda5ca024a.jpg)
09重新输入密码。.
10再想要修改时,会提示已经不能更改了。. |