# Answer check: Excel Formula Changes When Copied Down? Lock the Rate Cell

With a 10% rate in F1, =B2*$F$1 returns 10, 8, and 5 when filled down from C2 to C4. The subtotal reference moves; the rate reference stays fixed.

The practice data is fictional. Reconcile each row before applying the method to a real file.