Sorting a subtotal list by the subtotals

K

Ken W

Is there some way that I can sort the totals of a list and leave the
underlying data there, or do I need to copy out the summarize data and then
sort that?
 
D

dlw

copy out the subtotals by highlighting them, then Edit/go to/Special/visible
cells only, then copy and paste
 
J

Jim Thomlinson

Are you creating your subtotals using Insert -> Subtotals. If so then you
could create a pivot table instead. That would allow you to sort by the
subtotaled amounts.
 
Top