How can I create a tree structure (multi-level list) in Excel?

Asked Apr 17 '12 at 18:58

Active Apr 17 '12 at 20:16

Viewed 3,468 times

I need to create tree structure in Excel, like a mindmap. As far as I know, it's impossible, so I want to create a multi-level list instead, like in Word:

1     |
1.1   |
1.2   |
1.3   |
2     |
2.1   |
2.1.1 |
2.2   |

It should be not a simple text, but a real multilevel list: when I insert string after 1.1, it's first cell becomes 1.2, 1.2 and 1.3 becomes 1.3 and 1.4 respectively.

edited Apr 17 '12 at 20:16

slhck

223,558
70
607
592

asked Apr 17 '12 at 18:58

Selivanov Pavel

Do you want this list to automatically update if you insert or delete rows? – shufler Apr 17 '12 at 20:32
Yes. And if there is some other way to make a tree structure in Excel, it will be an answer too. – Selivanov Pavel Apr 17 '12 at 21:02

How can I create a tree structure (multi-level list) in Excel?

0 Answers0