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.

Remove subtotals and turn off outlining before you apply Remove Duplicates. If you're new to Microsoft Excel 2007, take time to study the Remove Duplicates feature, as it did not appear in Excel 2003.

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

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.