Insert subtotals
- To sort the column that contains the data you want to group by, select that column, and then on the Data tab, in the Sort & Filter group, click Sort A to Z or Sort Z to A.
- On the Data tab, in the Outline group, click Subtotal. ...
- In the At each change in box, click the column to subtotal.
Can you sort a subtotal in Excel?
It is a list where we have used the Automated Subtotal feature from the Data ribbon. ... If you want to sort the amount column from largest to smallest for the subtotals amounts you can select the Amount cell C1 and then click the Sort Descending icon in the Data ribbon tab – see below.
How do you sort values after subtotal in Excel?
To sort after subtotal, you just need to do as these:
- Select the data that you want to subtotal, and then click Data > Subtotal.
- In the Subtotal dialog, check the column you want to subtotal to, see screenshot:
- Click OK, and the data has been subtotaled.
