如何在Excel中锁定单元格

下载PDF文件
下载PDF文件

锁定Excel电子表格内的单元格能够防止单元格中的数据或公式被删改。被锁定和保护的单元格可以由最初锁定它们的用户对其解除锁定。参考以下步骤了解如何在Microsoft Excel 2010、2007和2003中锁定和保护单元格。

方法 1
方法 1 的 2:

锁定和保护单元格：Excel 2007和2010

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    所选单元格现在将被锁定和保护，要对解除对它们的锁定，你必须再次选中它们并输入所设置的密码。
    广告
方法 2
方法 2 的 2:

锁定和保护单元格：Excel 2003

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    所选单元格现在将被锁定和保护，要对解除对它们的锁定，你必须再次选中它们并输入所设置的密码。
    广告

小提示

  • 如果你的Excel文档能被多个用户存储，请锁定包含重要数据或复杂公式的单元格，避免其内容被意外地更改。
  • 如果你的Excel文档中大部分的单元格包含有重要数据或复杂的公式，可以考虑锁定或保护整个文档，然后再对部分允许被更改的单元格解除锁定。
广告

你可能还喜欢

如何
向Illustrator中添加字体
如何
登录Twitter
如何
下载YouTube视频
如何
从网站上免费下载视频
如何
保存Instagram上的图片
如何
更改YouTube语言设置
查看Instagram而不注册账号
如何
使用VPN
如何
从SIM卡中获取你的手机号码
如何
打开EPUB文件
如何
绕过YouTube的年龄限制
如何
关闭YouTube限制模式
如何恢复被冻结的Twitter账号
如何知道自己是否被Discord上的好友拉黑了
广告

参考

  1. http://answers.vt.edu/kb/entry/1913/
  2. http://www.dummies.com/how-to/content/how-to-protect-cell-data-in-excel-2010.html

关于本wikiHow

其他语言
本页面已经被访问过19,354次。

这篇文章对你有帮助吗？

广告