Outline help required
 

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

Outline help required
 

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

Outline help required
 

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

Outline help required
 

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