Is this what you mean?
Select row 5,
<Shift <Alt <RightArrow
Select rows 4 and 5,
<Shift <Alt <RightArrow
Select rows 4 to 10,
<Shift <Alt <RightArrow
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
"Tricia S." wrote in message
...
Yes, this is what I am looking for. Thanks. I do have one more question,
tho.
It appears as though the levels of grouping must be consistent all the way
down the column. Is there a way to have such a structure (notice the
different grouping levels)?
Red Basket
Apple
Green
Red
Banana
Orange
Tangerine
Tangelo
Navel
Seedless
Blue Basket
Broccoli
Peas
Carrots
Baby
Sliced
Shredded
Finely
Coarse
Corn
"RagDyeR" wrote:
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!
==============================================
"Tricia S." wrote in message
...
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
"galimi" wrote:
Bob,
This feature is located under the Data menu, Group and Outline, Group
and
select Rows or Columns. You should highlight the rows or columns that
you
wish to group prior to clicking on that feature.
http://HelpExcel.com
"bob sacco" wrote:
I already did this in an old excel worksheet but I CAN'T remember HOW
I
DID IT.
The result is a (plus) + and a (minus) - sign at the top of the
worksheet in
row 1 at the location where you want your selected columns to either
expand
or collapse.
I need to once again implement this handy formatting trick but for the
life
of me remember how I did it....so frustrating!
Anyone out ther know how to do this?