Free demo · Microsoft Excel · Lesson 5 · Basics · Cell references
Absolute references: lock a cell with the $ sign
The fill handle moves every reference in a formula. When all rows must use one cell, such as a discount rate, lock it with $: press F4.
- 1In C2 type
=B2*F1: the fee × the rate in F1 - 2Press Enter: 1500 × 10% = 150
- 3Fill down: 0, 0, 0? C3 became
=B3*F2: F1 slid down to empty cells - 4Edit C2, click on
F1in the formula, press F4:$F$1 - 5Fill down again:
=B3*$F$1,=B4*$F$1… only the B part moves - ✓Change F1 to 15%: every discount updates at once