excel表格怎么設(shè)置自動計算?對于初學excel的朋友,不知道excel的有些功能,今天小編就教你們excel表格設(shè)置自動計算的辦法吧。希望對你有幫助!
excel表格設(shè)置自動計算的辦法
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.選擇兩個方框輸入兩個數(shù)據(jù)。此處以輸入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.點擊答案應(yīng)該所在的方框,輸入“+”;
![](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函數(shù)求最高值的方法”