1
Shift + SpaceSelect the target rows
Decide which detail rows you want to bundle first.
groupingcollapsehierarchical view
How to Group and Collapse Rows and Columns Together
Details are too long to show in full, but you do not want to delete them. Grouping is exactly the right tool for that situation.
Shortcuts you will master in this article
Alt + Shift + → / Alt + Shift + ← / Shift + Space
Forcing a show/hide binary makes documents harder to use
In meetings you want to show only totals, but drill into details when necessary. Grouping is the right middle ground for that requirement.
Unlike hiding, grouping preserves the collapsing intent, making shared documents easier for others to navigate.
Basic grouping workflow
Starting with row groups is easiest to understand.
2
Alt + Shift + →Group the rows or columns
Makes the selected rows or columns collapsible as a unit.
3
Alt + Shift + ←Ungroup
Easily remove grouping when it is no longer needed.
4
1 / 2 buttonsBuild a totals-only view
Use the level buttons on the left edge of the sheet to toggle how much detail is shown. The effect grows with longer documents.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Situations where grouping is most useful
Ideal for tables that combine monthly details and totals on the same sheet.
Good when you want one sheet to serve both working and presentation purposes.
When sharing with others, make sure headings clearly indicate where collapsible sections are.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Shift + Space | Select Entire Row |
Ctrl + Space | Select Entire Column |
Frequently Asked Questions
Q. What is the difference between hiding and grouping?
A. Grouping preserves the fold structure, making it easy to expand later — that is the key difference.
Q. Can I use this with columns too?
A. Yes. Column groups are useful in wide comparison tables.
Q. Some recipients dislike grouping in shared files.
A. It happens. Depending on the recipient's workflow, consider whether to fix the expanded state in the final version.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →