Subtotals

Tips, Tricks, and Answers

The following articles are available for the 'Subtotals' topic. Click the article's title (shown in bold) to see the associated article.

Copying Subtotals
If you have added subtotals to your worksheet data, you might want to copy those subtotals somewhere else. This is easy to do using a special feature of the Go To command.

Counting with Subtotals
The subtotaling features of Excel are used, quite often, to sum information in a data table. You aren't limited to summing, however. You can use subtotaling to also provide a count of records, as described in this tip.

Formatting Subtotal Rows
Using Data | Subtotals you can add different types of subtotals to a data table. These subtotals are normally shown in bold, but you may want to apply other types of formatting. This tip provides several different approaches you can take toward that formatting.

Moving Subtotals
When you add subtotals to a worksheet, Excel normally places them in whatever column seems best to it at the time. If you want to move these subtotals to a different column, it can be a tedious task. This tip provides a macro that makes moving the subtotals a snap.

Problems with Nested Subtotals
If you have a worksheet that has nested subtotals, you may have run across a problem where the subtotals and grand total appear out of order. This is a definite problem with Excel, and you'll appreciate the pointer to the solution, provided in this tip.

Subtotals Option Grayed Out
The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. If the option is grayed out—not available—in Excel 2003, then it could be because the data table has been defined as a list.

Using Subtotals and Totals
You can insert subtotals and totals in your worksheets by using either a formula or specialized tools. This tip explains how to do both.