Shortcutdrill

Level 9: Grouping and structure Drill 73 of 80 Pro

Collapse all groups

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

The sheet has three row groups. Collapse them all so only the summary rows show.

What this drill teaches

Alt, A, H hides the detail of the groups. With nothing selected inside a group it collapses them all.

A hint if you get stuck

Windows: Alt, A, H. The drill allows 1 key press.

This drill is part of Pro

Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.

14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.

Start with the free drills

More drills in Grouping and structure