Worksheet: how to sort and insert subtotals

How to Insert Subtotals Through Multi-Sort

In this example, we have a worksheet file tagged by Office in the Alias 1 column and wish to sort and subtotal.

1. From the Item ribbon tab, Select Insert Subtotal By Column   
   
   
2. The Multiple Column Sort dialog will then appear.
   
   
3. Put a check mark next to the column(s) you wish to sort by. Notice that the first checked column in the list is in bold font. This indicates the Primary Sort column and will be used to insert subtotals. If you want to change the primary sort column, use the up or down arrow buttons to move that column above the others so that it appears in bold. In this specific example, I have checked Alias 1 as my primary sort field and I have my secondary sort by part number.
   
   
4. Put a check mark next to Insert Subtotals after each unique value of the primary sort field.
   
   
5. Click OK.

Note: The Worksheet is now sorted by Alias 1 and the secondary sorted by part number, with a subtotal inserted after each unique alias value.