ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reduce subtotals all at once? (https://www.excelbanter.com/excel-discussion-misc-queries/116669-reduce-subtotals-all-once.html)

tim m

Reduce subtotals all at once?
 
Greetings,

When I use subtotals the data comes out in expanded form. Is there a way to
quickly reduce to just see the subtotals for the whole sheet rather than
clicking the - sign for each subtotal change in data?

Thanks!

tim m

Reduce subtotals all at once?
 
Okay I'm a dummy, of course you just click on the numbers at the top of the
subtotals to reduce or expand. Need more coffee this am!!!

"tim m" wrote:

Greetings,

When I use subtotals the data comes out in expanded form. Is there a way to
quickly reduce to just see the subtotals for the whole sheet rather than
clicking the - sign for each subtotal change in data?

Thanks!



All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com