| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping
I have a worksheet that is about 7000 rows long. Right now I have it grouped
5 ways: 1- Quarter,2-Month,3-Date,4-Department,5-items made. Right now I am selecting two blank rows per department and grouping 1 department at a time. Is there a easier way to do this? Thank you very much for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
grouping
Depending on what you're doing, maybe a pivottable summary would be
easier/better. Or if you want, you could sort your data and do data|subtotals. arepemko wrote: I have a worksheet that is about 7000 rows long. Right now I have it grouped 5 ways: 1- Quarter,2-Month,3-Date,4-Department,5-items made. Right now I am selecting two blank rows per department and grouping 1 department at a time. Is there a easier way to do this? Thank you very much for your help. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel should allow me Indian number grouping ##,##,##,###.## | Excel Worksheet Functions | |||
| Pivot Table Grouping or Calculated Field | Excel Discussion (Misc queries) | |||
| How do I get the grouping dialogue box to appear in Pivot Tables? | Excel Worksheet Functions | |||
| Protected cells and grouping | Excel Discussion (Misc queries) | |||
| grouping of cells in protected sheets | Excel Worksheet Functions | |||
Hybrid Mode
