Step 3: The group buttons appear at the top.Uncheck the box “summary rows below detail.” Click on “create” to complete the process. Step 2: The dialog box, as shown in the following image, appears.Step 1: Click on the dialog box launcher under the “outline” section of the Data tab.The steps to group data with preceding totals are listed as follows: Let us add the totals before the data of a particular country. In the previous method, the totals were added at the end of every country. The consolidated summary of every country can be seen, as shown in the following image. Clicking the plus sign (+) hides the sub-items of each country.Clicking on “auto outline” groups the range included in the country-wise total.Click on “auto outline” in “group” under the Data tab. To each country, add subtotals manually, as shown in the following image.In an Excel sheet, enter the data as shown in the following image.The steps to create an auto outline with succeeding subtotals are listed as follows:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |