Question

How can you insert subtotal into a sheet?​

Answer 1

Answer: To insert subtotal into a sheet.

 1) Select a cell in the list, and on the Excel Ribbon, click the Data tab, then click Subtotals.

2) In the "At each change in" box, select the first column that you want to base the subtotals on -- Category in this example.

3)  Select the function that you want to use when totaling the columns.

4)  Select all the columns in which you want a subtotal.

5)   Remove the check mark from "Replace current subtotals" (unless there are existing subtotals that you want to remove).

 6)  Check or uncheck the page break and summary below data options, based on your preferences.

 7)  Click OK, to apply the Subtotals.

                              Hope this helps you :-)

Answer 2

Explanation:

pls mark it as brainliest