How to Use Subtotals and Totals in an Excel Spreadsheet

Creating Labels for Your Spreadsheet
1. Start Microsoft Excel and open the file you want to change.
2. Enter label titles for your columns and rows.
3. Drag over the column that contain the label titles.
4. Click B (boldface icon) on the tool bar.
5. Drag over the row that contain the label titles.
6. Click B (boldface icon) on the tool bar.
Creating Subtotals and Grand Totals
7. Drag over the columns and rows for which you want to create subtotals and grand totals.
8. Open the Data menu and select Subtotals.
9. In the Subtotal dialog box, select the columns names you want subtotaled in the 'Add subtotal to' option.
10. Select OK.