Outline/group data below
On 13 Mar., 17:59, Shane Devenshire
wrote:
Hi,
I am not clear on what you want. *Could you show us some sample data?
In general the group and outline command can be done by selecting the rows
you want to group and choosing Data, Group, Rows. *However the +/- reside on
the far left. *If you want those icons in the spreadsheet you are going to
need to use a pivot table.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Leon" wrote:
Hi Group
Using excel 2007.
I want to make e group - outline - of rows.
Want to have a line with a number and some text
[+] 8 text here
when i click the [+] it turns to [-] and the group appears over the
line #8
I want to have the group apper below the line *#8...
How do I do that?- Skjul tekst i anførselstegn -
- Vis tekst i anførselstegn -
What I mean is..
I want to have row 9 to 15 hidden/collapsed in a outlined group.
the [+] sign is on row 16.
I want it on row 8.
Can it be done?
|