An Overview of Calculation Options in Excel

The Calculation Options choose the way you calculate in Excel. Sometimes, it is convenient for us to receive a result from the calculations instantly, or sometimes it is best to recalculate at the end. The good news is, that you can change when and how Excel recalculates formulas using the Calculation Options. This article will give you an overview of the Calculation Options and how to use them in Excel.

How to Use Calculation Options in Excel

To use Calculation Options in Excel, follow the steps below:

  1. First, click on the Formulas tab.
  2. Now from the Calculation group, hit the Calculation Options drop-down menu.Location of Calculation Options in Excel
  3. You will see the Automatic mode is the default mode.Automatic Mode of Calculation Options in Excel
  4. From the Calculation Options drop-down menu, choose any mode as per your preference.
    To activate the Manual mode, click on the Manual command.Manual Mode of Calculation Options in Excel
  5. Choose the Calculate Now or the Calculate Sheet command to recalculate again.Calculate Now and Calculate Sheet beside Calculation Options in Excel

Modes of Calculation Options in Excel

The Calculation Options in Excel allow you to compute in 3 distinct ways.

1. Automatic

Generally, the Automatic option is the default setting in Excel sheets. The Automatic mode is for recalculating when a formula, function, value, cell address, or cell range is changed. It also plays an active role when a formula is filled in multiple cells.

2. Automatic Except for Data Tables

The recalculation feature stays active with the Automatic Except for Data Tables calculation mode, except, it is inactivated for Data Tables.

3. Manual

The Manual mode stops the automatic recalculation method. To reactivate the Automatic mode, click the Calculate Now or Calculate Sheet command.

Keyboard Shortcuts for Using Calculation Options in Excel

  1. Automatic Mode: Press ALT+A.
  2. Automatic Except for Data Tables Mode: Press ALT+D.
  3. Manual Mode: Press ALT+M.


Microsoft Excel’s Calculations Options are beneficial if you know how to properly use them in worksheets. I hope you get an overall idea of when to use which of the Calculation Options in Excel. Please visit our Blog page for more Excel-related writing. Also, don’t forget to comment if you find anything confusing. Thank you.

Excel Glossary | Autosum | Fill Handle | Conditional Formatting | Merge & Center | Wrap Text | Flash Fill | Find & Replace | Freeze Panes | Format Painter | Format Cells | Sort & Filter | Advanced Filter | Text to Columns | Go To Special | Name Manager | Excel Table | Slicer | Power Query | Add-ins

Rate this post

Leave a Reply

Your email address will not be published. Required fields are marked *