How to format subtotals in Excel What this list needs is some formatting to make those vendor subtotals stand out. At the left, you can see the three grouping levels: 1, 2 and 3.

The first one is Replace current subtotals, which will remove any subtotals currently in the dataset with the new ones. By default, this is already checked. Although I did not have any existing ...

Subtotals are common in a lot of Excel spreadsheets, and they’re usually the result of a simple expression or function. For example, you might have a simple revenue sheet that tracks debits and ...

Click the "2" in the outline area on the left to collapse the worksheet so that only the totals are visible. Highlight the rows. Although you can see only the totals, if you copy them now Excel ...

Select the cells that contain the subtotals. With this example, these subtotals are dollar figures. Click "OK" to close the dialog boxes and insert the summary chart.