Problem with Multiple Groups of Rows

Depends on what Rows you have selected before you setup the group.
The selection depends if you have the +/- signs above or below your grouping.

If you have your +/- signs at the top of the group and want to group Rows 1-10, select rows 2-10 and hit Shift-Alt-Right arrow to group. (Shift-Alt-Left arrow to remove grouping).
To group 11-20, select 12-20 and hit Shift-Alt-Right arrow.

If you have the "Summary rows below detail" checked, (+/- signs at bottom of grouping), select 11-19 then setup your grouping.

not sure what you are trying to accomplish, grouping is basically for summarizing data. so when you create a group and collapse it there still has to be something showing i.e the total for the collapsed rows.

because of this you can't set set different groups for sequential rows. in your example when you group rows 1-10 and collapse it row 11 would still show. this would typically be the summary row.

heres more info:
http://office.microsoft.com/en-us/e...worksheet-HA010024498.aspx?pid=CL100570551033

Thanks for the replies!

It is an order form with 50 rows, but most of them will usually be blank. I was trying to group them so that the "+ / -" would be a single click to hide & unhide rows as needed. Sounds like I can't use grouping in the way I want since I don't have a summary row.

Thanks again!

if you leave a blank row between sections you want to group you can do what you want. thats'll act as a dummy totals row but you'll still se one blank row for each section