PDF download Download Article PDF download 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.

  1. 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 .
  2. You'll see this in the editing ribbon above the document space.
    Advertisement
  3. You'll see this under the icon of a calculator in the "Calculation" group.
  4. 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]
  5. Advertisement


Expert Q&A

Ask a Question
      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!

      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.

      Is this article up to date?

      Advertisement