Why your formula broke when you copied it
Lock a cell with $ so a formula keeps working when you copy it down.
Do this lesson on your computer.
It runs beside a practice Excel in your browser, and every step is checked as you go. Free, with no sign-up.
On your computer, go tolearnford.com/go/GX5R
The full Excel course: 217 lessons, US$149.
Lifetime access, a practice Excel in your browser, and new lessons as we add them.
See the Excel courseIn this lesson
- A relative reference (F1) moves when you copy the formula.
- An absolute reference ($F$1) stays on F1 wherever the formula lands.
- F$1 locks only the row, $F1 only the column. $F$1 is always safe.