How do you create a hierarchical list in Excel? - Excel Tip and Tricks #tip #excel #shorts

Learn how to create a hierarchical list in Excel. In other words, how do I create a multi level hierarchy in excel? Some people like to ask how do I create a hierarchy list. I will give you an example of a hierarchy list in this video.

These are the steps covered in the video.

1) Select names
2) Ctrl + C
3) Insert ~ Illustrations ~ SmartArt
4) Hierarchy
5) Select any hierarchical type you like.
6) Ok
7) Delete original [Text]
8) Ctrl + V
9) Tab on name to change hierarchical order.

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

[arungowda]

This is great work, thanks for sharing this

[stephaniehuynh]

What?!?! 🤯 I’ve been under a rock for not knowing this

[thehoov]

That still requirea the initial list to be in some order. Like if a name in your list is 3 below the person they report to, then the TAB function won't work correctly.

[yoman]

Dude, I had an assignment to do this 2 weeks ago. I manually made the chart in Word.

[tscimb]

jfc THANK YOU FOR THIS!
I could *not* figure out how to make this work. Tried all sorts of nonsense, with no success.

[hiiloveindia]

thanks, nice video, what would you do if a person has a Dual Reporting line to two different managers.