Grouping in Excel works best for structured worksheets that have column headings, no blank rows or columns, and a summary row (subtotal) for each subset of rows. Group rows automatically (create an outline) With the data properly organized, use one of the following ways to group it.
Go to the Data tab > Outline group, click the arrow under Group, and select Auto Outline.Select any cell in one of the rows you want to group.If your dataset contains just one level of information, the fastest way would be to let Excel group rows for you automatically.
Here is an example of what kind of rows Excel can group:Īs shown in the screenshot below, the rows have been grouped perfectly and the outline bars representing different levels of data organization have been added to the left of column A. To create a new group faster, press the Shift + Alt + Right Arrow shortcut instead of clicking the Group button on the ribbon. 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. Approach and retract macro is disabled.
0 kommentar(er)
