Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.

Group data In the PivotTable, right-click a value and select Group . In the Grouping box, select Starting at and Ending at checkboxes, and edit the values if needed.

The GROUPBY function allows you to group, aggregate, sort, and filter data based on the fields you specify. The syntax of the GROUPBY function is: …

You can create a basic grouped report by using the Report Wizard, you can add grouping and sorting to an existing report, or you can revise grouping and sorting options that have already …

Press and hold down the Ctrl key and select the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, select the first worksheet tab in the range, press and …

To sort the column that contains the data you want to group by, select that column, and then on the Data tab, in the Sort & Filter group, click Sort A to Z or Sort Z to A. On the Data tab, in the …

Use Excel with your keyboard and a screen reader to group or ungroup the data in a PivotTable. We have tested it with Narrator, NVDA, and JAWS, but it might work with other screen readers …

You can group data by using an aggregate function, such as Sum and Average. For example, you want to summarize the total units sold at the country and sales channel level, grouped by the …

When you aggregate data, you group data by attributes such as product, price, region, or date and then define a formula that works on all the data in the group. For example, when you …

To group shapes and other objects, on the Drawing Tools Format tab, click Group > Group. Ungroup shapes, pictures, or other objects Select the group that you want to ungroup.