tree list in EXCEL cell

[chuikingman]

Hi,
I want to create tree list in the excel sheet ,
look like tree .
Any idea how I can do it ...
please advice in detailed ..

 

[moonfish]

Do you mean a pivot table, perhaps?

Make sure the data you want to put into a 'tree list' is in one table and that each column has a header. Now select this data and (in Excel 2007) select Insert > PivotTable.
Put your tree 'folders' in the row labels part of the table.

 

[chuikingman]

Do you mean a pivot table, perhaps?

Make sure the data you want to put into a 'tree list' is in one table and that each column has a header. Now select this data and (in Excel 2007) select Insert > PivotTable.
Put your tree 'folders' in the row labels part of the table.

I use 2003 excel
Please advice ...

 

[moonfish]

Try this tutorial for Excel 2003:
http://www.mrexcel.com/excel-pivottable-videos.html

 

[chuikingman]

Try this tutorial for Excel 2003:
http://www.mrexcel.com/excel-pivottable-videos.html

Not pivot table .
i want to create tree .....

 

[Hermanito]

Maybe data grouping is what you want?

Check here:
www.youtube.com/watch?v=Smoakwe34bE
and here:
http://www.tutorialized.com/tutorial/GROUP-and-UNGROUP-in-Excel/23347

for demovideos