Outline (group) data in a worksheet - Microsoft Support
Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.
Group or ungroup data in a PivotTable - Microsoft Support
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.
GROUPBY function - Microsoft Support
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: …
Group rows of data (Power Query) - Microsoft Support
In Power Query, you can group the same values in one or more columns into a single grouped row. You can group a column by using an aggregate function or group by a row. Example
Create a grouped or summary report - Microsoft Support
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 …
Insert subtotals in a list of data in a worksheet - Microsoft Support
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 …
Group or ungroup shapes, pictures, or other objects - Microsoft …
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.
Combine text from two or more cells into one cell
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbol (&) Select the cell where you …
Use a screen reader to group or ungroup data in a PivotTable in …
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 …
Group worksheets - Microsoft Support
You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are …