原因:双击时鼠标在两个单元格的边框或是四个单元格的交叉点上,这时鼠标左键双击会自动跳。解决的方法是关闭“启用填充柄和单元格拖放功能”,操作流程如下:
所需材料:Excel 2007演示。
一、打开Excel窗口后,点击左上角“Office按钮”(其他版本点击“文件”)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aa64034f78f0f7362ce71d7f1a55b319ebc413b6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、弹出的菜单中点击打开“Excel 选项”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/78310a55b319ebc43f6127e79226cffc1e1716b6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、打开Excel选项窗口后,点击左侧的“高级”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d04f27f5c1b0ec08fa513dc6b7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、找到“启用填充柄和单元格拖放功能”,取消勾选该项,点击该窗口“确定”,设置完之后,双击单元格边框时就不会再自动跳转(注意:关闭该功能后,单元格自动填充功能也会失效,需要使用时在Excel选项中再打开该功能即可)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a044ad345982b2b72b8668ba21adcbef76099bb7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)