ShortcutdrillPaste formulas 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
E12 totals Revenue and is bold with a top border. Copy its formula into D12 to total Units, without carrying the bold and the border across.
What this drill teaches
Paste Special with Formulas pastes the formula, references adjusted, and leaves the destination formatting alone. A plain Ctrl+V would bring the bold and the border with it.
A hint if you get stuck
Windows: Ctrl+C, Left arrow, Ctrl+Alt+V, F, Enter. Mac: Cmd+C, Left arrow, Cmd+Ctrl+V, F, Return. The drill allows 3 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 Alt ribbon sequences
- Autofit the columnFree
- Sort by this columnPro
- Bottom borderPro
- Paste values onlyFree
- Paste formats onlyPro
- Paste transposedPro
- Freeze the headerPro
- Blue font for inputsPro
- Wrap textPro
- Insert a pivotPro
- Hide the helper columnsFree
- Unhide themPro
- Freeze the top rowPro
- Freeze the first columnPro
- Sort A to ZPro
- Highlight the cells to checkPro
- Center the headersPro
- Top border on the totalPro
- Delete the scratch sheetPro
- Outline borderPro
- Remove the bordersPro