ShortcutdrillExpand the group
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 5 to 9 are grouped and collapsed, and you are in A10, just below them. Show the detail rows again.
What this drill teaches
Alt, A, J is Show Detail, the reverse of Alt, A, H. From a cell in or next to the group it expands that group; from outside every group it expands them all.
A hint if you get stuck
Windows: Alt, A, J. The drill allows 1 key press.
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
- Hide the rowsPro
- Unhide the rowsPro
- Hide the column you are inPro