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. But, you can rename the Default Group Name in Pivot Table to make it more meaningful. In this article, I will explain how to rename a Default Group Name in Pivot Table.
How to Rename a Default Group Name in Pivot Table: 2 Creative Methods
Here, I will demonstrate two easy methods for renaming a Default Group Name in Pivot Table. Furthermore, for your better understanding, I’m going to use the following dataset which has 4 columns. Those are Employee, Location, Group, and Sex.
Now, I will show you how to make a Pivot Table.
- Firstly, select the data range.
- Secondly, from the Insert tab >> go to the Pivot Table feature >> then choose From Table/Range option.
At this time, a dialog box named PivotTable from table or range will appear.
- Now, make sure that you have chosen the Table/Range.
- Then, mark the New Worksheet option.
- Finally, press OK to get the result.
- After that, drag Group and Location to the Rows area.
- Then, drag Sex to the Columns and Values areas.
Finally, you will see the Pivot Table.
The formatted Pivot Table is given below.
1. Use of F2 Button to Rename a Default Group Name in Pivot Table
You can use the F2 button for renaming a Default Group Name in Pivot Table. You may follow the steps given below.
Steps:
- Firstly, you have to select the data. Here, I have selected the A5 cell.
- Now Press F2 from your keyboard.
At this time, you will see the cursor in the cell.
- After that, use BACKSPACE to delete the existing group name and enter a new group name. Here, I have changed Group 1 into Western Zone and Group 2 into Eastern Zone.
Read More: How to Group Rows in Excel Pivot Table
2. Using Formula Bar to Rename a Default Group Name in Pivot Table
You can use the Formula Bar for renaming a Default Group Name in Pivot Table. You may follow the steps given below.
Steps:
- Firstly, you have to select the data. Here, I have selected the A5 cell.
- Next, go to the Formula Bar.
- Then, press BACKSPACE to remove the default name.
- Now, write down your preferred name in the Formula Bar. Here, I have written “Western Zone” in the Formula Bar.
- Similarly, do for the other name.
Finally, you will get renamed Pivot Table.
Read more: Pivot Table Custom Grouping
💬 Things to Remember
- Both of the methods are so easy and simple. So, you can use any of them.
Download Practice Workbook
You can download the practice workbook from here:
Conclusion
I hope you found this article helpful. Here, I have explained 2 suitable methods for renaming a Default Group Name in Pivot Table. Please, drop comments, suggestions, or queries if you have any in the comment section below.
