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

1

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.

Selivanov Pavel

Posted 2012-04-17T18:58:51.190

Reputation: 160

Do you want this list to automatically update if you insert or delete rows? – shufler – 2012-04-17T20:32:58.200

Yes. And if there is some other way to make a tree structure in Excel, it will be an answer too. – Selivanov Pavel – 2012-04-17T21:02:27.150

No answers