Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
How do you create a hierarchical list in Excel? - Excel Tips and Tricks
8 Views • Aug 14, 2025
Description
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.
How do you create a hierarchical list in Excel?,How do I create a multi level hierarchy in Excel?,How do you create a hierarchy list?,What is an example of a hierarchy in Excel?,How do I create a hierarchy filter in Excel?,
More from User
How do you align charts to cells in Excel? - Excel Tips and Tricks
ExcelTips247
Hide cell values in Excel - Excel Tips and Tricks
ExcelTips247
How do I add a Choosecols function in Excel? - Excel Tips and Tricks
ExcelTips247
Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks
ExcelTips247
Consolidate Data from Multiple Table Using SUMIF() in Excel... Another method - Excel Tips and Tricks
ExcelTips247
3D SUM to in Excel to consolidate data from multiple worksheets - Excel Tips and Tricks
ExcelTips247
Related Videos
How do I create a dependent drop-down list in Excel - Excel Tips and Tricks
ExcelTips247
Excel Tips and Tricks - How To Create Dynamic Numbering List
ExcelTips247
Create a dropdown list in Google Sheets - Excel Tips and Tricks
ExcelTips247
List of Excel functions in any versions of Excel - Excel Tips and Tricks
ExcelTips247
How to Create an Excel Interactive Chart with Dynamic Arrays - Excel Tips and Tricks
ExcelTips247
Create a 5 Star Rating System in Excel - Excel Tips and Tricks
ExcelTips247