Exploding Views

[Guest]

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

 

[Guest]

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

 

[Sandy Mann]

I assume that you have data Grouped. Highlight the data that you want to
Group then select Data > Group ans Outline > Group

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Sandy,

Thank you. That's what it is.

Sprinks

I assume that you have data Grouped. Highlight the data that you want to
Group then select Data > Group ans Outline > Group

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Mike,

Thanks for your response. It turns out that the data is grouped as Sandy
suggests.

Sprinks

 

[Sandy Mann]

You are welcome Spinks.

It may still be that Mike is also right about you having SUBTOTAL()'s at the
end of the hidden data, (ie the cell that you can see), because SUBTOTAL()
ignores other SUBTOTAL()'s and so a final SUBTOTAL() at the bottom will not
add in all the intervening SUBTOTAL()'s

--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk