Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.