Excel like a finance pro.
← 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 1000 · Capable
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.
Meet your AI CFO →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.