subgroups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Friedrich Vosberg - 25 Nov 2006 11:07 GMT

Morning.

Is it possible to create subgroups subordinated to grouped columns or
rows?

+-----------------------,
+-----------, %% This subgroup i'ld need.
| | | | |
-----|-----|-----|-----|-----|-----
| | | | |
-----|-----|-----|-----|-----|-----

TIA and kind regards, Friedrich

Signature

Kinderlärm ist Zukunftsmusik.

vatolin (at) mac (dot) com

Reply to this Message

Jim Gordon MVP - 25 Nov 2006 15:56 GMT

Hi Friedrich,

Perhaps a Pivot Table is what you are seeking. Visit this URL and see if
this is what you are looking for.
http://www.contextures.on.ca/xlfaqPivot.html

-Jim Gordon
Mac MVP

Quoting from "Friedrich Vosberg" <post@vatolin.de>, in article
1hpcxjj.1pm45qw9ioadxN%post@vatolin.de, on [DATE:

> Morning.
>
[quoted text clipped - 9 lines]
>
> TIA and kind regards, Friedrich

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

JE McGimpsey - 26 Nov 2006 03:48 GMT

> Morning.
>
[quoted text clipped - 7 lines]
> | | | | |
> -----|-----|-----|-----|-----|-----

I'm not sure what you mean by "subordinated to", but you can certainly
group columns under other groups. Just make sure the "outer" group is
expanded when you group the "inner" columns/rows.

Reply to this Message

Mac Forum / Applications / Excel / November 2006

subgroups