Modified grouping help
 

Ok, for the company I work for I have an excel sheet the contains data
of all the items we are selling through Sears.com. Each item has 1
code number for us, then 1 to 15 colors. So eash item can take up 1
row or up to 15 or more. I want to group thiese together, for the sake
of the filtering.

When a user filters to show only those items that, say are currently on
sale, it only shows the first row of that item. I would like to be able
to group all the items together so when they do this type of filter,
they can click on the "+" and then view every of the colors/codes for
that item. The problem is that excel groups under the last item
selected.

Very simply, excel groups the rows 1,2,3,4 under 5. So if they are
hidden the sheet goes 5,6,7,8,9. What I want to do is group 2,3,4
under the 1. So if they are hidden the sheet says 1,5,6,7,8,9. Since
the first of each item is considered the main item/color combo, all the
others need to be under it. How can I do this? I have searched all
over to no avail.


--
neicedover1982
------------------------------------------------------------------------
neicedover1982's Profile: http://www.excelforum.com/member.php...o&userid=32320
View this thread: http://www.excelforum.com/showthread...hreadid=520751

Modified grouping help
 

Goto Data Group and Outline
Then Choose Settings

Uncheck the box marked 'Summary row below detail'

Hope this helps
George

neicedover1982 wrote:
Ok, for the company I work for I have an excel sheet the contains data
of all the items we are selling through Sears.com. Each item has 1
code number for us, then 1 to 15 colors. So eash item can take up 1
row or up to 15 or more. I want to group thiese together, for the sake
of the filtering.

When a user filters to show only those items that, say are currently on
sale, it only shows the first row of that item. I would like to be able
to group all the items together so when they do this type of filter,
they can click on the "+" and then view every of the colors/codes for
that item. The problem is that excel groups under the last item
selected.

Very simply, excel groups the rows 1,2,3,4 under 5. So if they are
hidden the sheet goes 5,6,7,8,9. What I want to do is group 2,3,4
under the 1. So if they are hidden the sheet says 1,5,6,7,8,9. Since
the first of each item is considered the main item/color combo, all the
others need to be under it. How can I do this? I have searched all
over to no avail.

Modified grouping help
 

Thank you George. Its such a simple answer I cant belive I couldnt find
the help anywhere else. :)


--
neicedover1982
------------------------------------------------------------------------
neicedover1982's Profile: http://www.excelforum.com/member.php...o&userid=32320
View this thread: http://www.excelforum.com/showthread...hreadid=520751