Question

write steps for creating subtotals​

Answer 1

Explanation:

Ensure that the columns have labels. Select the range of cells that you want to calculate subtotals for, and then choose Data > Subtotals. In the Subtotals dialog, in the Group by list, select the column by which the subtotals need to be grouped. A subtotal will be calculated for each distinct value in this column

Answer 2

Explanation:

Ensure that the columns have labels. Select the range of cells that you want to calculate subtotals for, and then choose Data > Subtotals. In the Subtotals dialog, in the Group by list, select the column by which the subtotals need to be grouped. A subtotal will be calculated for each distinct value in this column.