Question

what is the use of subtotal future in Excel write the steps to use subtotal option​

Answer 1

Answer:

On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed.

In the At each change in box, click the nested subtotal column. ...

In the Use function box, click the summary function that you want to use to calculate the subtotals. ...

Clear the Replace current subtotals check box.