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