Fortunately, a few quick formatting tricks will make them stand out, loud and clear. How to format subtotals in Excel What this list needs is some formatting to make those vendor subtotals stand out.

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

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.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...