Question

write steps to insert subtotal values into a sheet?​

Answer 1

Answer:

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.

Answer 2

Answer:

Insert subtotals

1. 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.

2. On the Data tab, in the Outline group, click Subtotal. ...

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

Explanation:

Hope it help you.