Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Ask your questions and receive precise answers from experienced professionals across different disciplines. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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.

Thank you for choosing our service. We're dedicated to providing the best answers for all your questions. Visit us again. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.