How to make a hierarchy tree in Excel

Written by stephen byron cooper | 13/05/2017
How to make a hierarchy tree in Excel
You can create a hierarchical structure in Excel. (Microsoft Corporation)

A family tree is an example of a hierarchical tree. Other examples are organisational charts in businesses and the bill of materials in manufacturing. Excel includes a facility called “Smart Art” that can automatically create a hierarchical tree.

Open a new Excel worksheet. Click on the “Insert” tab in the menu bar. Select “Smart Art” in the “Illustrations” section of the tab. A dialogue window will open.

Create the structure of your tree by selecting “Hierarchy” from the list of categories in the left panel of the window. Click on the format that you like most in the middle panel and see an example in the right panel of the window. Click the “OK” button to get your outline on the spreadsheet.

Click on the outward pointing arrow on the left side of the frame around the new hierarchy. This shows the hierarchy as indented levels of text with bullet points. Click in the top level to write the text that will appear in the top box of the hierarchy. Press down arrow on your keyboard to go down to the first box on the next level.

Expand your hierarchy by pressing the “Enter” key while in the last entry for a level to add another box at that level. Press “Tab” or “Backspace” to move a box up or down a level in the hierarchy. Press the right mouse button to get the right-click menu. Select “Promote” from this menu to move a box up a layer, or “Demote” to push it down a layer. If you demote a box on the current bottom layer, you will move it onto a newly created lower layer.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.