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
There are a variety of ways you can count information in different groupings. One convenient way is to use the subtotaling capabilities provided in Excel.

   Excel Refuses to Put Page Breaks between Subtotal Groups
Page breaks not appearing where you expect them in your subtotaled data? It could be because of a setting you made in your page setup.

   Formatting Subtotal Rows
Excel automatically formats subtotals for you. But what if you want to change the default to something more suitable for your worksheet? Here's how to change the formatting of subtotals whether you use them sparingly or frequently.

   Moving Subtotals
When you add subtotals to a worksheet, Excel typically places them in the same column that you are subtotaling. If you want those subtotals moved to a different column, you'll appreciate the techniques described in this tip.

   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.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.