How to manipulate hierarchical breakdown in Excel

Question

Please consider below screenshot

We can see that the tasks and corresponding items under it are properly grouped in a tree hierarchy. I wasn't able to figure out how I can manipulate this hierarchy in excel or create one from scratch. Please advise.

With rows selected, CTRL+SHIFT+RIGHT to create a group, and CTRL+SHIFT+LEFT to remove a group. Or go into the Data tab, and find the buttons for it. — Christofer Weber, May 06 '19 at 22:19
Then, @ChristoferWeber should post is as an answer.. and the asker will give a tick. || This will remove this question from "unanswered" question list, and benefit the future readers. — p._phidot_, May 15 '19 at 07:51

Christofer Weber · Accepted Answer · 2019-05-15T11:37:21.107

2

It's called an outline or group, and can be done on both rows and columns. For a more technical in-depth explanation, check out the Office Support page on the topic (Or google excel grouping).

You find the options for this under the Data tab:

But you can also group via the shortcuts Alt+Shift+→ (add) or Alt+Shift+← (remove) while having the rows or columns selected.

edited May 15 '19 at 11:37

answered May 15 '19 at 11:19

Christofer Weber

1,323
1
8
14

You can also use the "Subtotals" tool. – Burgi May 15 '19 at 11:46
1

@fixer1234 Unfortunately I don't know. My Excel isn't in english, so I borrowed and modified an image from the web, which already had the arrows in it. – Christofer Weber May 15 '19 at 20:07

How to manipulate hierarchical breakdown in Excel

1 Answers1