TOPIC 01
Spreadsheet references
A relative cell reference moves when copied. A dollar sign locks the row or column that follows it.
Copy =B2*$E$1 from C2 down to C3. What does the formula become?
Reveal answer
=B3*$E$1. The relative row changes and the fixed reference stays E1.