Try taking a look at SubTotals under Data on the main menu. This is the
only native Excel functionality that has this kind of behaviour (without
going into controls that is).

Saxy46 wrote:
Hello,

I am interested in creating a status report for a website that I am
working on. I saw an excel spreadsheet that is pretty much exactly
what I am trying to do but I don't know how they created it. I want
the spreadsheet to have an expandable tree format. For instance, I
will list 5 major sections to the website. These sections will be able
to expand when you click on the +. Then under them you will see more
sections broken down with +, listing all the pages that will be on the
site. From that I want to implement a progress dropdown showing the
progress of the site from completion, in progree, not posted, etc.
This will then relate back to a field back up at the 5 main sections
stating the percentage of completion. I can figure out how to do the
whole percentatge stuff, but I dont know how to make the sections
expandable. Does any one know? Am I being clear with my description?

Thanks in advance for your help.