Group Cells

6 lessons in order

Group similar items in Excel using sorting, PivotTables, Subtotal, formulas, GROUPBY, or UNIQUE function for organized, summarized data.

Learn how to group rows by cell value in Excel using the GROUPBY function, Data tab, Pivot Table, and Power Query.

Learn how to group rows and add subtotals in Excel using the Subtotal feature, SUBTOTAL function, and create multi-level summaries easily.

Learn how to group similar text in Excel by color using formulas, VBA customization, or the built-in Sort by Color feature.

Learn how to create separate groups in Excel by name using Name Box, Define Name, Name Manager, and formulas for dynamic grouping.

Learn how to group data in Excel without repeating values using Remove Duplicates, unique formulas, filters, and smart grouping methods.