OK - thanks for your reply... I guess I still need more claification...
I have Acct #, Disc, detail1, detail2, detail3, detail 4
I want a list of Acct # -- if I toggle I want to see all details.
Which do I select? - the data cells for everything except the Acct # column?
When I try that I still get only 2 levels - one shows only header line - the
other shows everything.... sam as when I selected the full row.

thansk again for your help....
--
Cindy B


"Duke Carey" wrote:

It sounds as though you are selecting ALL the rows, and that won't work.

You need to select the contiguous subsets of rows that will be grouped so,
for your first Acct's detail, select JUST those detail rows, then press
Shift-Alt-Right Arrow


"Cindy B" wrote:

Thanks for the reply - I must be doing something wrong- I'm just just not
getting the expected results....
My spreadsheet has Acct #, Acct disc, then several columns of detail
information.
When I highlight the rows and select Group (or the key board shortcut) I get
only 2 levels - it is all or nothing. I do not have the option to toggle by
the acct number column. Literally everything hides at level 1 - everything
shows at level2. What I would expect/want is the option to show a list of
acct #'s or toggle that open to show Acct detail. I am able to get that
using the subtotal count.
If I try to do Group-Outline I get a message "cannot create an outline".
Does this have anything to do with ranges - tables - data types???

thanks again for your help
--
Cindy B


"RagDyeR" wrote:

What you're looking for is called "Group & Outline",
under <Data in the Menu Bar.

Some keyboard shortcuts:

Select rows 1, 2, and 3 by clicking on the row headers.
Then:
<Shift <Alt < Right Arrow
To group those selected rows.

<Shift <Alt < Left Arrow
To ungroup them.

Same works for columns.

To toggle the outline symbols to hide and unhide:

<Ctrl < 8
Using the #8 from the numbers under the function keys, *not* the number on
the num keypad.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Cindy B" wrote in message
...
Hi-
I think this must be doable, but can not quite "get it". I want to group a
sheet by the first column - and be able to expand it to see the detail when
wanted.
If I do a subtotal and do a count or sum - I pretty much get what I want -
but I really have no field to logically count or sum - so when someone else
is looking at it- it doesn't make sense.
Can I get that same expansion capability by using grouping instead of using
Subtotal????

thanks for help! - Cindy
--
Cindy B