is it possible to create grouping in Excel? Example I have 3 item under a title Salary: Wages, Bonuses, Travel Claim. Whai I want to achieve was allow user user click to show or hide the sub item. Just like the Folder Tree you have where you click on the folert icon to hide the sub folder.

Under your excel menu, go to Data->Subtotal. Use this function to perform grouping. However, the first dtep to using this function is to highlight the columns that you want to group...
If you have further questions, post here and I will do my best to help you...

Thanks obenix, this is what I want. Saw this on someone screen just dunno how to do it.