Lesson 250: How to Group Pivot Table Items in Excel

This article will show you how to Group Pivot Tabs in Excel.

I will use the pivot table below as an example for you. You can read this article to learn how to create a pivot table.

How to Group Pivot Table Items

Product Group

1. In the pivot table, select Apple and Banana.

2. Right-click and select Group

3. In the pivot table, select Beans, Broccoli, Carrots, Mango and Orange.

4. Right-click and select Group

Result

Group day

1. Click any cell inside the column with the date.

2. Right-click and select Group

3. Select Quarters and press OK

Result

In addition, you can also see many other excel articles here.