how do create subtotals ?
please answer me
help me
Answers
Answered by
9
Explanation:
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.
Answered by
2
Answer:
1) click one of the cells containing your data
2) click data > subtotala
3) In the subtotals box, click OK. tips: once you've added your subtotals, on outline graphic appears to the left of your data. you can click on the number buttons along the top of the graphic to
expand and collapse the data.
Similar questions