How to rename a default group name in Pivot Table

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.

How to rename a default group name in pivot table.

Select the group name which you want to change.

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.

How to rename a default group name in a pivot table

Use backspace to delete the existing group name and then enter a new name.

We have changed group1 into Western Zone and group2 into Eastern Zone.

How to rename a default group name in a pivot table

Changed group name.

Download Sample File to work with this example

Employee-list.xlsx

Happy Excelling 🙂


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply