ExcelBanter - sorting detail rows - summary row in an outline

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sorting detail rows - summary row in an outline (https://www.excelbanter.com/excel-discussion-misc-queries/1264-sorting-detail-rows-summary-row-outline.html)

ExcelSteve

sorting detail rows - summary row in an outline

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

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!

ExcelSteve wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 03:37 PM.