When you group some items in a pivot table, Excel provides a default group name such as Group1 for selected items, or Jan for dates in the month of January. You can rename the group to make it more meaningful following the steps below:
Rename a Default Group Name in Pivot Table
Step 1: Select the group name:
Just click on the group name to select it.
Step 2: Press F2
Now Press F2 from your keyboard.
Step 3: Enter a new group name
Use backspace to delete the existing group name and enter a new group name.
We have changed group1 into Western Zone and group2 into Eastern Zone.
Download Sample File to work with this example
Happy Excelling 🙂