Sorting, Grouping, and Filtering Cells

The Excel sort function and Excel filter function are highly useful when working with large amounts of data.

Grouping cells using the Subtotal command

Grouping is a useful Excel feature that gives you control over how the information is displayed. You must sort before you can group. In this section, we will learn how to create groups using the Subtotal command.

To create groups with subtotals:

Subtotal Example

To collapse or display the group:

Outline Group Commands

To ungroup select cells:

To ungroup the entire worksheet: