Group / collapse rows

[drfrot]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

In the past I've been shown spreadsheets that have little plus signs to the left of the row numbers. Clicking these collapses & un-collapses rows into groups.

Which feature of Excel is this?

I have large amounts of "tiered" data (from Level 1 to Level 6, as column headings), that I'd like to view tier by tier, or group and un-group, or collapse and un-collapse, if you like. A crude representation is below:

What I have...

Level 1 text
Level 2 text
More level 2 text
Level 3 text
Level 3 text
Even more level 2 text
And some more level 2 text
Level 3 text
Level 3 text
Level 4 text

What I would like....

- Level 1 text
Level 2 text
+ More level 2 text
Even more level 2 text
- And some more level 2 text
Level 3 text
+ Level 3 text

Any pointers?

Cheers

Giles

 

[drfrot]

Hmmm, okay, the tabbing in my wish list hasn't exactly come out how I'd imagined, but you get the picture!

 

[CyberTaz]

Written for PC Excel but works the same in the Mac versions:

<http://office.microsoft.com/en-us/excel/HA100244981033.aspx?pid=CL100570551
033>

HTH |:>)
Bob Jones
[MVP] Office:Mac