Copy Excel Formula

2009-02-08 8:17 am
各位好,
我在MYOB export data去 excel,在 report中用了=SUM(C20:D20), copy拉下去時變成同一數目,並不懂得自動計算,要每個cell按F2+ENTER才可自動計算,而且就算改了其中一個數亦要再按F2+ENTER才可自動計算,好慘呀。
更新1:

當然是如何解決。即可以copy formula, cell位置會身自動轉變,答案亦會身自動轉變。

回答 (4)

2009-02-11 6:23 am
✔ 最佳答案
Pls check:
1) Tools > Options > Calculate(Tab)
2) Make sure Automatic option is selected

note: you may also Click on the buttons on the right handside to update calucation for current worksheet or entire workbook.

I hope this helps.

Calvin Lee, [email protected]
2009-02-10 8:38 pm
簡單方法1:

你"在MYOB export data去 excel,在 report中用了=SUM(C20:D20)," 後按 F9, Excel 會懂得自動計算
2009-02-08 8:38 am
甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢甘你想點呢
2009-02-08 8:36 am
唔緊要啦



小小苦楚 = 激勵


收錄日期: 2021-05-01 16:31:04
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090208000051KK00050

檢視 Wayback Machine 備份