不能下拉是由于表格设置成手动重算模式了
材料/工具:Excel2010
1、首先我们打开我们电脑上面的excel,然后在表格中输入一些数据,依照图示,我们可以看到那是个自动求和的公式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4e6ca6430d3c451da81cb3eba?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、我们右击选择复制那个单元格的公式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb135e4d84bd5a81ea8d3fd1f4445?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后我们点击图示中的单元格,点击粘贴;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faf2b2119313b07e458eac6602d7912397dd8ca9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、结果我们看到公式并没有自动更新,33加44显然不等于55,我们点击工具栏中的公式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd1005686044f7c8b4710b9122f42?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、弹出的界面,我们在右边找到计算选项,点击其下拉箭头;
6、弹出的界面,我们点击自动,之后就会在自动的前面出现一个勾选;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9345d688d43f87945defb440dc1b0ef41bd53a48?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、此时我们可以看到前面的公式已经变成自动更新了,答案变成了77了,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/242dd42a2834349b7ea992ebc7ea15ce36d3be35?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)