Sounds like you received a spreadsheet that had been subtotalled.

Once you have your information (Eg Name, cost centre, amount), sort by the
most relevant heading. Then select Data / Subtotals and it should
automatically highlight the information that you're working on. From there
select the appropriate course of action. (eg at the change in every cost
centre, use the Sum function and apply it to amount).

If you would like to add another change (i.e. after name, then repeat the
subtotal process, but ensure that the Replace Current Subtotals box is
unchecked.

HTH

Mike



"Sprinks" wrote:

I recently received a project estimate that had three levels of exploded
views--byclicking on a plus sign, the information expands to more detail.
Also, the spreadsheet had a window on the left side with buttons labeled 1,
2, and 3. Clicking the 1 showed the executive summary view, 3 the most
detailed, and 2 an intermediate level.

Is this native Excel functionality, or does anyone know of an add-in that
provides it? I would like to incorporate this feature into workbooks that we
produce.

Thank you.

Sprinks