Tuesday, December 13, 2011

How to Use Subtotals in 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.

Blogger news