Westonci.ca offers quick and accurate answers to your questions. Join our community and get the insights you need today. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

collapse the entire outline to show just the subtotals

Sagot :

Select the worksheet data.

Go to the Data menu in the ribbon and look in the Outline group.

Click on the Subtotal command.

Select how you want it subtotaled (in our example, this would be by location and for each of the ice cream treat categories).

Click OK.