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

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.

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.

Click the Data tab. Click Subtotal in the Outline group. In Excel 2003, Subtotals is on the Data menu. In the resulting dialog, choose Count from the Function dropdown.

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.