Sort question involving groups

  • Thread starter Thread starter Mike Connolly
  • Start date Start date
M

Mike Connolly

Hi All,

I have a worksheet where I have used the group buttons to hide details in
the rows under a summary row. When I sort on columns, the detail rows get
lost in the sort. In other words the detail rows are no longer below the
correct summary row. Is there away to keep the rows together?

thanks,
Mike
 
Dear Mike

The details row are needed to be hidden with help group button so that
after sorting(as the "groups" will be sorted & not the detail records)
they will move along with their summary row.

Regards
NC
 
Hi,

Excuse me, I'm kind of a novice. I didn't get what you mean by "hidden
with help group button".
I did hide the detailed rows using Format>Row>Hide. But, didn't help. The
detailed rows are still getting mixed up in the sort.

Thanks,
Mike
 
well mike

by word "hide" i just mean collapse the rows so that only summary rows
would be visible with a + sign on the left of worksheet. (data>group &
outline>hide details)

i do not mean hiding then by Format>Row>Hide.
i hope this clarifies

Regards
NC
 
Back
Top