Microsoft Excel:  Subtotals

Microsoft Excel can automatically calculate subtotal and grand total values in a list. When you insert automatic subtotals, Excel outlines the list so that you can display (expand) and hide (collapse) the detail rows for each subtotal.

Before you insert subtotals, you first must sort your list so that the rows you want to subtotal are grouped together. You can then calculate subtotals for any column that contains numbers.

1. Place the cell selector in your spreadsheet.
2. From the Data menu, select Subtotals…

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.