Outlining function without subtotals


J

Jeff

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).
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top