Writing formulas
- Select a cell and type = to begin a formula.
- Click a cell or type its reference, such as A1, to use its value.
- Combine references with operators like + - * / to calculate.
- Reference a range with a colon, for example A1:A10.
- Press Enter to confirm; the cell shows the result while the formula bar shows the formula.
Tip Use $ to fix a reference, such as $A$1, so it does not shift when the formula is copied or filled.