Page 616 - Excel 2013 All-in-One For Dummies

598 Subtotaling Data
Excel does not allow you to subtotal a data list formatted as a table. Before you can use the Subtotal command button, you must first convert your table into a normal range of cells. To do this, click a cell in the table and then click the Design tab on the Table Tools contextual tab on the Ribbon. Finally, click the Convert to Range command button in the Tools group followed by the Yes button in the alert dialog box asking you to confirm this action. Excel then removes the filter buttons from the columns at the top of the data list while still retaining the original table formatting.
Figures 1-10 and 1-11 illustrate how easy it is to use the Subtotals feature to obtain totals in a data list. In Figure 1-10, I sorted the sample Employee data list first by the Dept field in ascending order and then by the Salary field
in descending order (Largest to Smallest) and converted the data list to a range. I then clicked the Subtotal command button on the Ribbon’s Data tab to open the Subtotal dialog box shown in Figure 1-10.
Here, I selected the Dept field as the field for which the subtotals are to be calculated in the At Each Change In drop-down list box, Sum as the function to use in the Use Function drop-down list box, and the Salary check box as the field whose values are to be summed in the Add Subtotal To list box.
Figure 1-10:
Using the Subtotal dialog box to subtotal the salaries for each department.