最近要做一個報告,Excel檔每一空格皆已預設公式, 國外上司教如何輸入所需數據如下:
打開Excel, 在下拉式視窗把公式/計算功能改為手動.
當計算功能改為手動, 你需要按F9去更新你所做的變動
To work with this file, you must have Office 2007. Before opening the file, I recommend to set the Calculation Option in Excel to Manual. Open Excel and navigate to Formulas\Calculation Options and select Manual in the dropdown window. When the Calculation Option is set to Manual, you’ll need to press the F9 Key to update the formulas after making changes in the worksheets.
問題是我找不到哪裡可以把計算功能改為手動阿? 救命救命~
X




























































































