Software categories:
Make Excel files read-only and hide all formulas and
algorithms.
ExcelLock is program that
locks down and secures your spreadsheet. The spreadsheet
becomes read-only, all formulas will be hidden and nothing can
be modified. Only the cells on the spreadsheet that you have marked can be modified. By default
all cells are read-only.
When you lock your spreadsheet
a copy of your file will be saved&with the extension&.lck.xls and
an unlock key will be generated. ExcelLock will apply strong encryption
so the binary .lck.xls file becomes scrambled.
The locked .lck.xls file
is password protected. It can only be opened by applying the unlock
key in the& ExcelLock viewer. It is not possible to open the
file directly in Excel. This ensures that while the file can
only be viewed, no formulas can be seen or modified, no
changes can be applied to the file.查看: 10142|回复: 3
如何Lock部分单元格不让别人编辑修改
阅读权限20
在线时间 小时
我有一些单元格，比如说从A2到M13这个范围内，我不希望别人修改我里面的公式什么的。我选中这些单元格（A2：M13）,而后右键--&Format Cells--&Protection 而后选中Locked。这时候看到Excel下面有了提示了说:"Locking或者Hiding Cells的时候，只有在Worksheet is protected的时候才会生效。于是我按照它的提示去tools-&Protection-&Protect Sheet...后面我就傻眼了，我只希望我的Locked cells不被别人修改就行了，别人select它都无所谓的。可是我不知道哪些选项好。一选“Select Locked Cells”那个“Select Unlocked Cells”也会被自动选上。不知道如何是好。其实我的要求并不复杂，可是Excel把我搞晕了。
(3.97 KB, 下载次数: 10)
19:10 上传
点击文件名下载附件
如何Lock部分单元格不让别人编辑修改
阅读权限30
在线时间 小时
(5.51 KB, 下载次数: 51)
19:27 上传
点击文件名下载附件
如何Lock部分单元格不让别人编辑修改
Unprotect Password is
阅读权限20
在线时间 小时
[建议]看看吧
看看是不是這樣的
(4.27 KB, 下载次数: 36)
10:56 上传
点击文件名下载附件
如何Lock部分单元格不让别人编辑修改
阅读权限20
在线时间 小时
回复 2楼 SaxophoneGd 的帖子
请问是如何将那些单元格保护起来的
最新热点 /1
本活动是由微软（中国）有限公司发起，申请通过者可以得到Office 365企业级E3 试用账号，并享有全套Office 365客户端及云端高效、协作办公体验。 机会有限，先到先得！
玩命加载中，请稍候
玩命加载中，请稍候
Powered by
本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！ & & 本站特聘法律顾问：徐怀玉律师 李志群律师How to Lock Cells in Excel 2016
How to Lock Cells in Excel 2016
Melanie Pinola
October 31,
You've worked hard on your spreadsheet and now you want to make sure anyone you share it with doesn't inadvertently change cells that shouldn't be changed. Thankfully, Microsoft Excel 2016 and earlier versions let you lock cells to protect them from being modified. You can lock all the cells in a worksheet or specific cells, allowing some parts of the spreadsheet to be changed. Here's how.
How to Lock All the Cells in a Worksheet
By default, when you protect a sheet or workbook, all of the cells will be locked. This means they can't be reformatted or deleted, and the content in them can't be edited. By default, the locked cells can be selected, but you can change that in the protection options.
1. Navigate
to the Review tab.
2. Click Protect Sheet. In the Protect Sheet window, enter a password that's required to unprotect the sheet (optional) and any of the actions you want to allow users.
3. Click OK to protect the sheet.
When you or anyone else tries to edit any of the locked cells, this message will come up:
The cells can only be unlocked when the sheet is unprotected (by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required).
How to Lock Specific Cells in a Worksheet
There might be times when you want to lock certain cells from being changed but still allow users to adjust other cells in a worksheet. In our example, in an inventory list you might allow unit prices and stock quantities to be updated, but not the item IDs, names, or descriptions. As mentioned above, all cells are locked by default when you protect the sheet. However, you can specify whether a cell should be locked or unlocked in the cell's format properties.
1. Select all the cells you don't want to be locked. These will be the cells that can be edited even after the sheet is protected.
2. Right-click on your selection, select Format Cells, and click on the Protection tab. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.)
3. Uncheck "Locked" (which is checked by default) and click OK.
Go to Review & Protect Sheet and hit OK to protect the sheet. Any cells you didn't unlock under the Format Cells option (step 3 above) will be locked, while the unlocked cells will be editable:
Note that cell locking (or unlocking) won't take effect until you do step 4, protecting the sheet.
Protip: If you want to quickly lock or unlock cells that aren't next to each other, you can use a keyboard shortcut. After selecting a cell or group of cells, use the Format Cells dialog as above to lock or unlock it. Then select your next cell(s) and hit F4 to repeat your last action.
You'd Also Like戴尔笔记本电脑，什么快捷键会让excel的小格子无法移动？被scream lock了？ - 知乎有问题，上知乎。知乎作为中文互联网最大的知识分享平台，以「知识连接一切」为愿景，致力于构建一个人人都可以便捷接入的知识分享网络，让人们便捷地与世界分享知识、经验和见解，发现更大的世界。3被浏览226分享邀请回答赞同 添加评论分享收藏感谢收起赞同 添加评论分享收藏感谢收起写回答查看: 8951|回复: 3
关于scroll lock 键 -已解决
阅读权限10
在线时间 小时
本帖最后由 xma2011 于
15:17 编辑
不知道在excel里按了什么键，excel就被锁屏，方向键不再在单元格里移动。我的键盘有些特殊，没有Scroll Lock键。
看过帖子说按FN+Num Lock， 我同时按过也没有解开锁屏。 看哪位高手可以指导迷津。多谢哈
刚在网上看到解决办法(使用虚拟键盘），如果大家有人遇到这种类似情况，请参照：
开始 --- 运行
输入osk.exe
阅读权限10
在线时间 小时
十分感谢 楼主好人！
阅读权限10
在线时间 小时
楼主自己把问题解决了，给我们踢狗了帮助，谢谢！
阅读权限10
在线时间 小时
万分感谢！
搜索关键字：键盘没有Scroll Lock键，Excel滚动锁定
最新热点 /1
本活动是由微软（中国）有限公司发起，申请通过者可以得到Office 365企业级E3 试用账号，并享有全套Office 365客户端及云端高效、协作办公体验。 机会有限，先到先得！
玩命加载中，请稍候
玩命加载中，请稍候
Powered by
本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！ & & 本站特聘法律顾问：徐怀玉律师 李志群律师}