how to create collapse and expand treeview in Excel 2010

**awarebase1** · 01-29-2013, 05:07 AM

can anyone say the answer please.....

**:) Sixthsense :)** · 01-29-2013, 05:44 AM

Can you please show / describe something???

**awarebase1** · 01-29-2013, 05:53 AM

Site1
SubSite1-1
Subsite1-2
Subsite1-3
Site2
SubSite2-1
SubSite2-2
SubSite2-3
and so on...
.
.
.
.
.

**awarebase1** · 01-29-2013, 05:58 AM

Site1 under Subsite1-1,SubSite1-2 and sooo on is there.....

when i click Site1 it will expand and again i click Site1 it will collapse

**:) Sixthsense :)** · 01-29-2013, 06:14 AM

Make use of pivot table. Refer the attached excel and Click the + button to expand and - to collapse.

Re: how to create collapse and expand treeview in Excel 2010