Exploding Views
 

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

Exploding Views
 

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

Exploding Views
 

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


with @tiscali.co.uk


"Sprinks" wrote in message
...
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

Exploding Views
 

Sandy,

Thank you. That's what it is.

Sprinks

"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Sprinks" wrote in message
...
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

Exploding Views
 

Mike,

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

Sprinks

"mike_vr" wrote:

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

Exploding Views
 

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


with @tiscali.co.uk


"Sprinks" wrote in message
...
Sandy,

Thank you. That's what it is.

Sprinks

"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Sprinks" wrote in message
...
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