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 don't really know if this will work, but why not try adding a blank or
dummy row to your single-name offices?
--
Anne Murray


"ArcticWolf" wrote:

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

Hi,

You can create an outline on a single row by highlighting a cell in that row
and then doing Alt+Shift+Right arrow. Now select row.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ArcticWolf" wrote in message
...
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

Hey Ash'

You are brilliant - this works perfectly. Thanks you for your assistance
and swift reply, much appreciated.

ATB,

AW

"Ashish Mathur" wrote:

Hi,

You can create an outline on a single row by highlighting a cell in that row
and then doing Alt+Shift+Right arrow. Now select row.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ArcticWolf" wrote in message
...
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