View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leon[_2_] Leon[_2_] is offline
external usenet poster
 
Posts: 25
Default 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?