Skip to main content

Excel Tips: Data > Group or Ungroup data

Group by range

How to assign a value or category based on a number range in Excel?

How to categorize data based on values in Excel?

How to group ages in ranges with VLOOKUP in Excel?

Group in PivotTable

How to group a pivot table by day of week in Excel?

How to group by age in pivot table?

How to group by fiscal year in an Excel pivot table?

How to group by range in an Excel Pivot Table?

How to group by week in pivot table?

How to group data by half a year in Excel PivotTable?

How to group data by half an hour or 15 minutes in Excel PivotTable?

How to group date by month/year/quarter in pivot table in Excel?

How to group time by hour in an Excel pivot table?

How to group time by minutes or hours intervals in Excel?

Others

How to assign serial number to duplicate or unique values in Excel?

How to expand all collapsed columns or rows in Excel?

How to expand or close all group rows and columns in Excel?

How to group adjacent columns or rows separately or independently in Excel?

How to group and ungroup rows in protected worksheet?

How to group or ungroup worksheets in Excel?

How to hide/unhide rows or columns with plus or minus sign in Excel?

How to highlight all subtotal rows at once in Excel?

How to move the group plus/minus sign to top in Excel?