ShortcutdrillLock the row only
An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.
The task
C13 multiplies B13 by the rate in B12. Lock just the row of the B12 reference (B$12), then fill C13 down to C16.
What this drill teaches
Two presses of F4 give B$12: the row is pinned and the column is free. That is enough for a fill down, and the formula still moves correctly if it is later filled right.
A hint if you get stuck
Windows: F2, F4 twice (B$12), Enter, select, Ctrl+D. Mac: Fn+F4. The drill allows 9 key presses.
This drill is part of Pro
Pro unlocks all 103 drills, with worked solutions and progress saved to your account. The free drills work without an account.
Annual starts with a 7-day free trial: $0 today, cancel before November 12, 2026 and you are not charged. 14-day refund on every plan, no questions. Cancel a subscription in one click. Founding price until 31 December 2026. Students: 50% off annual with a .edu or .ac email.
More drills in Formula editing speed
- Lock the column onlyFree
- Lock everythingFree
- Evaluate part of a formulaPro
- Fill a block with one formulaPro
- Sum across a blockPro
- Show the formulasFree
- Name the inputsPro
- Insert a function by namePro
- Add a commentPro
- Repeat the last actionFree
- Fix a reference in placePro
- Enter and stay putPro
- Copy the cell abovePro