Names, tracing formulas and calculation

Updated November 13, 2026

Names

  • Formulas › Define name gives a cell or range a name, such as TaxRate, to use in formulas.
  • Formulas › Create from selection names rows or columns from their headings.
  • Formulas › Name manager (Ctrl+F3) lists every name to edit or delete.
  • Formulas › Use in formula puts a name into the formula you’re typing.

See how a formula works

  • Trace precedents draws arrows from the cells a formula uses. Trace dependents draws arrows to the formulas that use this cell. Remove arrows clears them.
  • Show formulas (Ctrl+`) shows every formula instead of its result.

Calculation

  • Cloud Sheets recalculates as you type. Formulas › Calculate (Calculate Now) recalculates everything, and fetches the IMPORT functions again.

Was this article helpful?