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. When you try to copy the subtotals by ...

Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

Outline Excel's Outline feature builds upon its Subtotal feature -- or subtotals you incorporate manually -- to add the ability to group and outline related values in up to eight levels of detail.

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.

This is the demonstration file to accompany the article, How to calculate conditional subtotals in an Excel revenue sheet, by Susan Harkins.

5. As a result, Excel not only subtotals all data by employee, but it also creates groups and inserts outline levels automatically for your entire data range, as pictured below. 6.