Download Article
Download Article
By default, Excel will auto calculate any formulas every time you open a worksheet or edit the information in the data set that contains the formula. This wikiHow will show you how you can change the automatic calculator function on and off in Excel.
Steps
-
Open your document in Excel. You can either open your document from within Excel by going to File > Open or you can right-click on the file in your file browser, select Open With and Excel .
-
Click the Formulas tab. You'll see this in the editing ribbon above the document space.Advertisement
-
Click Calculation Options . You'll see this under the icon of a calculator in the "Calculation" group.
-
Select a calculation rule. You can choose:
- Automatic : the default option that tells Excel to refresh the calculation any time information in the formula's data range is edited.
- Automatic Except for Data Tables : also tells Excel to recalculate any formulas if the data in the formula's cells changes.
- Manual : turns off auto-calculations in Excel so you'll have to calculate manually. [1] X Research source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
1. Open your document in Excel.
2. Click the Formulas
tab.
3. Click Calculation Options
.
4. Select a calculation rule.
Did this summary help you?
Thanks to all authors for creating a page that has been read 30,251 times.
Advertisement