Answered

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 :

mel3351

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.

Visit us again for up-to-date and reliable answers. We're always ready to assist you with your informational needs. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.