excel表格怎么设置自动计算?对于初学excel的朋友,不知道excel的有些功能,今天小编就教你们excel表格设置自动计算的办法吧。希望对你有帮助!
excel表格设置自动计算的办法
1.打开一个EXCEL文件;
![](https://iknow-pic.cdn.bcebos.com/11385343fbf2b211a0219426c78065380cd78e4e?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
2.选择两个方框输入两个数据。此处以输入1,2为例进行加法运算;
![](https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbf14daa45214d8bc3eb1354177?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
3.选择需要填写答案的方框;
![](https://iknow-pic.cdn.bcebos.com/500fd9f9d72a60593a1ff0722534349b033bba4e?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
4.在此方框中输入“=";
![](https://iknow-pic.cdn.bcebos.com/5882b2b7d0a20cf471b7efb77b094b36acaf99b6?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
5.点击要参加运算的第一个自变量;
![](https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb43166b2f6b122da4462309f7d3a1?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
6.点击答案应该所在的方框,输入“+”;
![](https://iknow-pic.cdn.bcebos.com/caef76094b36acaf6bc7879471d98d1001e99cb6?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
7.点击另一个自变量;
![](https://iknow-pic.cdn.bcebos.com/d000baa1cd11728bd24b9d4ac5fcc3cec3fd2c77?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
8.点击回车,便得到答案。
![](https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d00c0fb5d7adec08fa513dc6a1?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg)
>>>下一页更多精彩“Excel函数求最高值的方法”