Question

How can you insert subtotal values into a sheet?​

Answer 1

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.

Answer 2

Answer:

$\bf\underline\red{Answer:}$

$\sf{Follow\:below\:steps\:to\: insert\: subtotal}$

$\sf{values\:into\:a \:sheet :-}$

• Sort the list on the field for which you want subtotals inserted.

• Click the Subtotal button in the Outline group on the Data tab.

• The Subtotal dialog box appears.

• Select the field for which the subtotals are to be calculated in the At Each Change In drop-down list.

• Specify the type of totals you want to insert in the Use Function drop-down list.

• Select the check boxes for the field(s) you want to total in the Add Subtotal To list box.

• Click OK.

$\bf{Finally,}$

$\sf\red{Excel\:adds\:the\:subtotals\:to\:the\: worksheet.}$

Additionally,

• Excel does not allow you to subtotal a list formatted as a table.

$\bf\underline\red{Thanks}$