ExcelBanter - adding subtotals to excel

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

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

- - adding subtotals to excel (https://www.excelbanter.com/excel-discussion-misc-queries/232828-adding-subtotals-excel.html)

alva

adding subtotals to excel

I am looking for the Tools Group so I can convert to Range...How do I turn on
the Tools Group?

Shane Devenshire[_2_]

adding subtotals to excel

Hi,

The best way to add subtotals is to use a pivot table - Data, PivotTable ....

However, the quick and dirty way is to choose Data, Subtotal...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"alva" wrote:

I am looking for the Tools Group so I can convert to Range...How do I turn on
the Tools Group?

All times are GMT +1. The time now is 07:19 PM.