A
ArcticWolf
Hi,
I have a sheet that is outlined but it doesn't 'outline' single rows of data
and I need it to.
Example: I have a sales office with 10 people in and it works fine, I click
'+' and it shows me the 10 names (their sales figures are in column B) and
when I click '-' it just shows the office name and the total sales for all 10
sales people - perfect!
But - I have a sales office with just one person in - and it doesn't give me
the option to + or - that office, it just shows the perons name. I know it
doesn't affect my totals so no problem there really but it would be useful to
+ and - and it show the sales office and not the single row.
Any ideas as to what I'm doing wrong?
Thanks in advance,
AW
I have a sheet that is outlined but it doesn't 'outline' single rows of data
and I need it to.
Example: I have a sales office with 10 people in and it works fine, I click
'+' and it shows me the 10 names (their sales figures are in column B) and
when I click '-' it just shows the office name and the total sales for all 10
sales people - perfect!
But - I have a sales office with just one person in - and it doesn't give me
the option to + or - that office, it just shows the perons name. I know it
doesn't affect my totals so no problem there really but it would be useful to
+ and - and it show the sales office and not the single row.
Any ideas as to what I'm doing wrong?
Thanks in advance,
AW