The Collapse and Expansion of Grouped DataĪt any point of time, the group can be collapsed and expanded.
![how to create multiple subtotals in excel 2016 how to create multiple subtotals in excel 2016](https://cdn.extendoffice.com/images/stories/doc-excel/insert-subtotals/doc-insert-subtotals3.png)
#How to create multiple subtotals in excel 2016 plus
![how to create multiple subtotals in excel 2016 how to create multiple subtotals in excel 2016](https://www.purposegames.com/images/games/background/440/440359.png)
Clicking on “auto outline” groups the range included in the country-wise total.Click on “auto outline” in “group” under the Data tab. To each country, add subtotals manually, as shown in the following image.In an Excel sheet, enter the data as shown in the following image.To remove subtotals from your list, click the Subtotals button and click Remove All in the Subtotal dialog box.The steps to create an auto outline with succeeding subtotals are listed as follows:.You can also click the control next to grand total to collapse all data. Use the controls in the left margin to expand or collapse the data for each group.Click the OK button to generate your subtotals and Grand Total.If unchecked, the subtotals appear above the data groups and the grand total appears at the top of the data. Summary below data: Places the subtotals at the bottom of each data group and places the grand total at the bottom of the data.Page break between groups: Puts each subtotal on its own printed page.
![how to create multiple subtotals in excel 2016 how to create multiple subtotals in excel 2016](https://www.myexcelonline.com/wp-content/uploads/2021/06/Create-multiple-subtotals-03.jpg)
Replace current subtotals: Replaces any existing subtotals on the sheet with the ones you create here.Click a checkbox to select the associated option: Below the Add subtotal to: box are additional options for subtotal layout.The default selection is the final column. In the Add subtotal to: box, select the columns that will be subtotaled.Max and Min: These selections identify the largest or smallest number in the selected column.Average: Computes an average from the data in the selected column.Count: Counts and displays the number of rows that contain data in the selected column.Sum: Adds the data in the selected column.The selected function is applied to the data in the column(s) you select from the Add subtotal to:Some of the most common selections are: Subtotaled from the Use function: dropdown menu. Select how you would like the data in your selected column.Select the column you chose to subtotal by from the At each change in: dropdown menu.Click the Subtotal button in the Outline group on the Data tab to launch the Subtotal dialog box.This will let you generate a subtotal for each item group in the column.
![how to create multiple subtotals in excel 2016 how to create multiple subtotals in excel 2016](https://www.techonthenet.com/excel/pivottbls/images/gtotal_row2016_001.png)
Sort the selected column (Column A in this example) so that the like items in it are grouped.Determine which column you want to subtotal.They are very useful when reviewing a table, as you can make small adjustments to see different perspectives on the information. Subtotals are dynamic in that they adjust instantly based on filters. By Excel Tips and Tricks from Categories: Excel® Tags: subtotals