How to Rename a Default Group Name in Pivot Table (2 Ways)

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.


Download Practice Workbook

You can download the practice workbook from here:


2 Methods to Rename a Default Group Name in Pivot Table

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.

Dataset for How to Rename a Default Group Name in Pivot Table

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.

Use of F2 Button to Rename a Default Group Name in Pivot Table

  • 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 Data in Pivot Table (3 Simple Methods)


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.
  • Secondly, go to the Formula Bar.
  • Thirdly, press BACKSPACE to remove the default name.

Using Formula Bar to Rename a Default Group Name in Pivot Table

  • 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.


💬 Things to Remember

  • Both of the methods are so easy and simple. So, you can use any of them.

Conclusion

I hope you found this article helpful. Here, I have explained 2 suitable methods for renaming a Default Group Name in Pivot Table. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Kawser

Kawser

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 them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo