How to Auto Calculate in Excel

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.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Auto-Calculate-in-Excel-Step-1.jpg\/v4-460px-Auto-Calculate-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/4\/4a\/Auto-Calculate-in-Excel-Step-1.jpg\/aid11747944-v4-728px-Auto-Calculate-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/15\/Auto-Calculate-in-Excel-Step-2.jpg\/v4-460px-Auto-Calculate-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/1\/15\/Auto-Calculate-in-Excel-Step-2.jpg\/aid11747944-v4-728px-Auto-Calculate-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this in the editing ribbon above the document space.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Auto-Calculate-in-Excel-Step-3.jpg\/v4-460px-Auto-Calculate-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/7\/78\/Auto-Calculate-in-Excel-Step-3.jpg\/aid11747944-v4-728px-Auto-Calculate-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this under the icon of a calculator in the "Calculation" group.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Auto-Calculate-in-Excel-Step-4.jpg\/v4-460px-Auto-Calculate-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Auto-Calculate-in-Excel-Step-4.jpg\/aid11747944-v4-728px-Auto-Calculate-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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
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
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Use Solver in Microsoft Excel
      Use Sum Formulas in Excel to Add Cells, Ranges, & Numbers
      How to
      Use the Sum Function in Microsoft Excel
      How to Create a User Defined Function in Excel
      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      Advertisement

      References

      1. ↑ https://www.got-it.ai/solutions/excel-chat/excel-tutorial/automatic-calculator-in-excel/how-to-auto-calculate-in-excel

      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 24,125 times.

      Is this article up to date?

      Advertisement