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