We can display multiple subtotal functions in excel using the following steps.
<u>Explanation</u>:
Step1: Enter the data you want to add in the excel sheet.
Step2: Select the cell containing the data you want to add.
Step3: Click the Data Tab
Step 4: Now select the SUBTOTAL command in the outline group.
Step 5: An option called ATEACHCHANGEIN will be available.
Step 6: Now select the drop-down menu under that option.
Step 7: After selecting the drop-down menu to select the columns you want to use for the first level subtotals.
By following these steps, we can display multiple subtotal functions in excel.
