← The libraryPractice · 5 questions →
Excel concept
Relative, absolute, and mixed references
A1 shifts when copied; $A$1 never moves; A$1 locks the row and $A1 locks the column.
Daily driverDifficulty 1109 · Proficient
The shape of it
- In practice
Press F4 while editing a reference to cycle the four forms.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.