![]() One of the most useful features of Excel grouping is the ability to hide and show the detail rows for a particular group as well as to collapse or expand the entire outline to a certain level in a mouse click. ![]() Now that we have an outline of rows, let's see how it makes our data easier to view. To have it done, select all the rows except for the Grand Total row (rows 2 through 17), and click Data tab > Group button > Rows.Īs shown in the screenshot below, our data is now grouped in 4 levels: If at some point more data is added to your worksheet, you will probably want to create more outline levels.Īs an example, let's insert the Grand total row in our table, and then add the outermost outline level. In practice, datasets are seldom complete. ![]() Similarly, we create nested groups for the North regions, and get the following result: To make the Oranges group, select rows 5 through 7, and press the Group button again. To create a nested (or inner) group, select all detail rows above the related summary row, and click the Group button.įor example, to create the Apples group within the East region, select rows 2 and 3, and hit Group. To create a new group faster, press the Shift + Alt + Right Arrow shortcut instead of clicking the Group button on the ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |