#1
|
|||
|
|||
2016 Excel Subtotal Function Changed
It appears the 2016 version of Excel dropped the auto-group function when you apply subtotals. Has anyone else experienced this and figured out how to get it back?
I tried to work around this by highlighting the entire subtotaled area and applying grouping based on the subtotals, but when you click the #2 group button, the subtotals go to 0. In the 2007 version, it would auto-group when I applied subtotals, and when you grouped the area to just see the subtotals (not all of the individual rows), it showed the values for each subtotal. Applying the grouping after the subtotal is in place doesn't appear to work. Thanks for your help! |
Tags |
grouping, subtotal, subtotals |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2016 "IF" Function Problem with 3 Ranges | Excelsior44 | Excel | 3 | 02-07-2017 05:46 PM |
Ms Excel 2016 IF function | IFnoob | Excel | 1 | 08-13-2016 11:34 PM |
Excel vlookup and subtotal? | monikersupreme | Excel | 3 | 02-15-2016 12:29 PM |
Excel file permissions suddenly changed | shnizel | Excel | 1 | 03-04-2014 06:12 PM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |