ShortcutdrillDelete the scratch column
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
Column F holds a scratch calculation that should not go out. You are in F5. Delete the whole column in two key presses.
What this drill teaches
Ctrl+Space selects the column, Ctrl+Minus deletes it and shifts everything to its right across. No dialog appears because a whole column is selected.
A hint if you get stuck
Windows: Ctrl+Space, Ctrl+-. Mac: Control+Space, Cmd+-. The drill allows 2 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 Grouping and structure
- Group the detail rowsPro
- UngroupPro
- Collapse all groupsPro
- Insert a sheetFree
- Rename the sheetPro
- Insert a columnFree
- Delete the blank rowFree
- Select the current regionFree
- Select to the end of the columnFree
- Extend across the row and downFree
- Delete three rows at oncePro
- Delete a row through the dialogPro
- Insert a column through the dialogPro
- Expand the groupPro
- Hide the rowsPro
- Unhide the rowsPro
- Hide the column you are inPro