Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) | |||
dynamically enter name of last modified by in spreadsheet on save | Excel Discussion (Misc queries) | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) |