Is this what you're looking for:
In a new test sheet,
Using the row headers,
Select rows 10, 11, 12,
Then <Shift> <Alt> <RightArrow>
Select rows 14, 15, 16,
Then, again <Shift> <Alt> <RightArrow>
Now select rows 9 to 17,
And, again <Shift> <Alt> <RightArrow>
Repeat the above, using rows
20, 21, 22,
24, 25, 26,
19 to 27,
Finally, select rows 8 to 28, and group them.
For this first test, you should use the rows exactly as I mentioned them.
This is because you *cannot* use adjacent rows when creating groups in the
*same level*.
XL requires a "total" (title) row between groups within the same level, or
it automatically *joins* them into one.
You can now expand or collapse the groups by either clicking on the plus and
minus signs, or clicking on the level numbers at the top.
You can do exactly the same grouping using columns also.
And of course, the keyboard shortcut to ungroup, is to use the Left Arrow in
place of the Right Arrow.
This link should give you a lot more insight into the finer points of
grouping:
http://tinyurl.com/6uc2p
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How do you make sub-groups within groups, similar to a Windows Folder
structure?
- Grand Parent 1
- Parent 1
Child 1
Child 2
- Parent 2
Child 3
Child 4
- Grand Parent 2
- Parent 3
Child 1
Child 4
- Parent 4
Child 5
I want to be able to collapse or expand Parents and Grand parents individual
of each other (Obviously, to see a parent, I'd need to have the Grand Parent
expanded). Exactly like the Folders behave in Windows Explorer