ShortcutdrillHide the rows
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
You are in B5. Hide rows 5 to 7 so the report shows only the other days.
What this drill teaches
Ctrl+9 hides the rows of the selection, the row partner of Ctrl+0. Shift+Space then Shift+Down extends a whole-row selection one row at a time.
A hint if you get stuck
Windows: Shift+Space, Shift+Down arrow twice, Ctrl+9. Mac: Shift+Space, Shift+Down arrow twice, Cmd+9. 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 three rows at oncePro
- Delete the scratch columnPro
- Delete a row through the dialogPro
- Insert a column through the dialogPro
- Expand the groupPro
- Unhide the rowsPro
- Hide the column you are inPro