Hello,

I am looking for a way to add the outlining qualities of the sub-total
function without actually having subtotals. I have recently come across a
spreadsheet that has the left margin set up with the outlineing feature as
if the subtotal function was run, but there are no actual subtotals. The
document is a site map and each of the columns indicate the outline level.
For example
Level 1 Level 2 Level 3
Alpha
Bravo
bravo-a
bravo-b
Charlie
Charlie-a
Charlie-c
Charlie-c-1
Charlie-c-2


If I click on the level one filter in the outline bar, only the level one
items appear, but I can select the individual areas to explode (I could
click on the "+" button next to Charlie to see the detail of Level 2, then
click on "+" next to Charlie-c to see that detail).

Select The necessary rows or columns and go to Data | Group and Outline |
Group to do this manually.
To extend your Subtotals analogy, you should group the rows or columns
similarly to how they are done with subototals.

You'll likely have to play a little to get it to work the way you want.
Here's a reasonable explanation with screenshots:
http://cma.zdnet.com/guides/qa_excel...22001_007.html

tj

"Jeff" wrote:

Hello,

I am looking for a way to add the outlining qualities of the sub-total
function without actually having subtotals. I have recently come across a
spreadsheet that has the left margin set up with the outlineing feature as
if the subtotal function was run, but there are no actual subtotals. The
document is a site map and each of the columns indicate the outline level.
For example
Level 1 Level 2 Level 3
Alpha
Bravo
bravo-a
bravo-b
Charlie
Charlie-a
Charlie-c
Charlie-c-1
Charlie-c-2


If I click on the level one filter in the outline bar, only the level one
items appear, but I can select the individual areas to explode (I could
click on the "+" button next to Charlie to see the detail of Level 2, then
click on "+" next to Charlie-c to see that detail).