View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Outline/group data below

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?