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: …
Sort data in a range or table - Microsoft Support
On the Data tab, in the Sort & Filter group, select Sort. In the Sort dialog box, under Column , in the Sort by box, select the column that you want to sort. Under Sort On , select Cell Color , …
Group worksheets - Microsoft Support
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 …
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
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.
Ways to count values in a worksheet - Microsoft Support
Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a …