sorting detail rows - summary row in an outline

E

ExcelSteve

Can I get detail rows to travel with the summary row in an outline when
sorting the entire list?
 
D

Dave Peterson

Did you use Data|Subtotals to obtain the subtotal rows?

If yes, if you collapse the details (and show only the subtotals), then sort, it
works!
 
Top