Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Problems with Nested Subtotals One day your subtotals work great; the next they are in the wrong order. This is not that far-fetched, and if it happens to you then you’ll need the information provided in this tip Microsoft Excel versions: 2002 | 2003

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. Microsoft Excel versions: 2003

Using Subtotals and Totals You can easily add subtotals or totals to a data table, but adding them both to the same column as your data could give erroneous results. This tip explains how to avoid such a pitfall, making sure you get reliable results that won’t lead you astray. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

ExcelTips
Excel 2007 Tips
WordTips
Word 2007 Tips
Vital News Home
 
ExcelTips FAQ
ExcelTips Premium
 
Learn Access Now
 
Beauty Tips
Car Care Tips
Cleaning Tips
College Tips
Cooking Tips
Gardening Tips
Health Tips
Home Improvement
Money Tips
Pet Tips
Tips.Net Home
 
Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)