Excel.Tips.Net ExcelTips (Menu Interface)


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.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.