Skip to main content
Workforce LibreTexts

18.8: The Calculation Group

  • Page ID
    13705
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    clipboard_ed0dc56d862993837e1106d5f4ae4bc62.png

    By default, Excel automatically calculates every formula automatically. This means that when values in a cell change, the formula recalculates immediately to display the correct information. However, there may be occasions when you do not want this to happen. The Calculation group allows the user to have flexibility in terms of when values are calculated. In most cases, the user should not change the Calculation Options from automatic, but it is nice that Excel provides the user the flexibility.

    The first icon, Calculation Options contains a drop-down menu that allows the user to quickly change the calculation setting in the active workbook between Manual, Automatic and Automatic except for Data Tables.

    The Calculate Now icon (F9) allows the user to recalculate all formulas in a workbook if the calculation setting was set to manual.

    Likewise, the Calculate Sheet icon- (Shift + F9). Allows the user to update all of the calculations in a worksheet if calculation settings were sent to manual.


    This page titled 18.8: The Calculation Group is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer (Minnesota State Opendora) .

    • Was this article helpful?