| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i use sort option when i used subtotal
can i use sort option when i used subtotal
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can i use sort option when i used subtotal
No you can not use sort with subtotals in place. You would need to remove the
subtotals, sort and then replace the subtotals. The re-sorting may mess up your ability to subtotal though. Have you considered a pivot table. it give you the same ability to subtotal and allows for a bunch of options including sorting the data after the fact. -- HTH... Jim Thomlinson "vj bansal" wrote: can i use sort option when i used subtotal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| SUBTOTAL Sort | Excel Worksheet Functions | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| sort subtotal groups | Excel Worksheet Functions | |||
| Excel subtotal group sort | Excel Worksheet Functions | |||
Hybrid Mode
