How to Use Subtotals in Excel 2003

If you have many numbers to crunch, subtotals can save time and make your worksheet more comprehensible. Follow these steps to add subtotals to columns in Excel 2003.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Excel 2003

1. Open your Excel worksheet with your data arranged in columns.
2. Select the column you want subtotaled. Hold down the left mouse button and drag down the column.
3. Under "Data" on the top menu, select “Subtotal” from the dropdown menu.
4. In the “Subtotal” pop-up window that appears, check the features you want in your subtotal, and then click "OK."
5. A subtotal of your numbers will appear on the worksheet. Save your work.

Tips & Warnings

• All of your numbers must be in the same column.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.