Recalculate formulas manually

You can manually recalculate outdated formula values in the entire document, on an open sheet, or in selected cells.

To recalculate outdated formula values in the entire document, do one of the following:

•On the Data tab, click the arrow to the right of the  Calculate data button and select  Calculate whole document from the drop-down menu.

•When working in macOS, select Data > Calculation mode > Calculate > Whole document command from the command menu.

•Press F9.

To recalculate outdated formula values on a sheet currently open, do one of the following:

•On the Data tab, click the arrow to the right of the  Calculate data button and select  Calculate sheet from the drop-down menu.

•When working in macOS, select Data > Calculation mode > Calculate > Sheet command from the command menu.

•Right-click the sheet tab and run the Calculate sheet command from the context menu.

•Press Shift+F9.

To recalculate outdated formula values in one or more selected cells, do one of the following:

•On the Data tab, click the arrow to the right of the  Calculate data button and select  Calculate selected cells from the drop-down menu.

•When working in macOS, select Data > Calculation mode > Calculate > Selected cells command from the command menu.

•Right-click the selected cells and choose Calculate selected cells command from the context menu.