Skip to main content

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 t_data_calculate_whole_document Calculate data button and select t_data_calculate_whole_document Calculate whole document from the drop-down 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 t_data_calculate_whole_document Calculate data button and select t_data_calculate_sheet Calculate sheet from the drop-down 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 t_data_calculate_whole_document Calculate data button and select t_data_calculate_selected_cells Calculate selected cells from the drop-down menu.
  • Right-click the selected cells and choose Calculate selected cells command from the context menu.