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.