Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.