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 themselves, ...

From the Not Just Numbers blog: I'm sure most of you are familiar with the SUM command for totalling ranges of cells, but have you heard of the SUBTOTAL command? - and if so, do you know what it does?

Most of us probably associate outlines with textual information rather than numerical data. In Excel, however, you can use outlines (and the accompanying Subtotal tool) to break data down into logical ...