Delete three rows at once
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
Rows 4 to 6 were entered twice. You are in B4. Delete all three rows in four key presses.
What this drill teaches
Extend the row selection with Shift+Down before Ctrl+Minus, and one press deletes the whole block. Deleting the rows one by one is three times the work.
A hint if you get stuck
Windows: Shift+Space, Shift+Down arrow twice, Ctrl+-. Mac: Shift+Space, Shift+Down arrow twice, Cmd+-. The drill allows 4 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 the scratch columnPro
- 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