Question: Outline and subtotal data Open the OutlineData workbook in Excel, and then perform the following tasks: Outline the data list in cells A 1 :D
Outline and subtotal data
Open the OutlineData workbook in Excel, and then perform the following tasks:
Outline the data list in cells A:D to find the subtotal for each year.
Hide the details of rows for the year
Create a new group consisting of the rows showing data for June and July
Hide the details of the group you just created.
Show the details of all months for the year
Remove the subtotal outline from the entire data list.
Save and close the file.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
