I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
a) Advisor
i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.

hi
these are subtotals.
on the menu bar...
data Subtotals

regards
FSt1

"DoveArrow" wrote:

I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
a) Advisor
i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.

select the column or row range then Data/Group/Group.

Some systems create this automaticly , but you can group lines or columns so
you can colaps / expand when you need

"DoveArrow" wrote:

I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
a) Advisor
i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.

On May 28, 11:33*am, Don wrote:
select the column or row range then Data/Group/Group. *

Some systems create this automaticly , but you can group lines or columns so
you can colaps / expand when you need



"DoveArrow" wrote:
I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
*a) Advisor
* i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.- Hide quoted text -

- Show quoted text -

Wow... that's so almost cool. However, it looks like there's a kind of
glitch with the last person in each group. When you have everything
open, you can't collapse their Academic Programs again. :-/

Is this why they took the "Analyze it With Microsoft Word" option out
from Microsoft Access 2007?

On May 28, 1:51*pm, DoveArrow wrote:
On May 28, 11:33*am, Don wrote:





select the column or row range then Data/Group/Group. *

Some systems create this automaticly , but you can group lines or columns so
you can colaps / expand when you need

"DoveArrow" wrote:
I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
*a) Advisor
* i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.- Hide quoted text -

- Show quoted text -

Wow... that's so almost cool. However, it looks like there's a kind of
glitch with the last person in each group. When you have everything
open, you can't collapse their Academic Programs again. :-/

Is this why they took the "Analyze it With Microsoft Word" option out
from Microsoft Access 2007?- Hide quoted text -

- Show quoted text -

Oh. Nevermind. I figured out that from the menu bar, if you click on
Data Group and Outline Settings, and then uncheck the box next to
"Summary rows below detail" it appears the way I want it to. Thanks.