Let’s try the three Outline buttons to see the difference in the data displayed: Individual records, subtotals, and grand total Table 5.5 Subtotal Outline Buttons Button Table 5.5 describes the different Outline buttons. These allow you to control the amount of subtotaled data that is displayed. Notice the three Outline buttons circled in the upper-left corner of the spreadsheet. Remove your subtotals using the Remove All button in Figure 5.24, sort your table, and then try subtotaling again.) (HINT: If you end up with more than one Subtotal for the same group (i.e – one of the days of the week in our example), you did not sort before subtotaling. Successful subtotaling shows only one subtotal for each group in the column you sorted by. It is essential that you select the column you sorted by in the “At each change in” field at the top of the window. In the Subtotal Window, make the choices shown in the Figure 5.24.Under the Data tab in the ribbon, click Subtotal.Because your data is no longer formatted as a table, your slicer will disappear and you will no longer have access to the Table Tools Design tab in the ribbon.
![add multiple subtotals in excel add multiple subtotals in excel](https://i.ytimg.com/vi/iHsAhxjSmjI/maxresdefault.jpg)
When asked if you want to convert the table, click Yes.To do this, click Convert to Range in the Table Tools Design tab on the ribbon. Before you can subtotal, you must convert your table back to a regular range.(See Figure 5.13 through 5.15 for a review of Custom Sorting.) Now we want to Sort the table by the Day column using a Custom Sort in the Sort button in the ribbon to sort in the order Sunday, Monday, Tuesday, etc.Remove all filters in the table by clicking the Data tab and then choosing Clear.Save your file before you start Subtotaling!.Right-click on the new Sheet tab, select Rename, type Subtotal OR, and then press ENTER.When you see a sheet icon with a + sign, let go of the mouse button and then the CTRL key.
![add multiple subtotals in excel add multiple subtotals in excel](https://docs.tibco.com/pub/sfire-cloud/latest/doc/html/en-US/TIB_sfire_bauthor-consumer_usersguide/bauthcons/images/cross_table_subtotal.png)
![add multiple subtotals in excel add multiple subtotals in excel](https://www.contextures.com/images/pivot/pivotsubtotal02.png)
This can provide Management with a report of higher level summary data one minute, and then can be easily switched back to detailed data the next minute. This is a powerful tool that allows you to quickly display multiple levels of summary data within your table. You can automatically calculate subtotals and grand totals in a table for a column.