• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Change Pivot Table Name

How to Change Pivot Table Name

By: Waseem Patwegar

It is really easy to change Pivot Table Name in Microsoft Excel. You will find below the steps to change the name of a Pivot Table, along with relevant screenshots.

Change Pivot Table Name

Change Pivot Table Name

When you create a Pivot Table, Microsoft Excel automatically names the Pivot Table as PivotTable1 and the next Pivot Table that you create is named as PivotTable2.

Instead of following this default naming convention, you can change Pivot Table Name to something meaningful and relevant to the data on the Pivot Table.

For example, Pivot Tables with names “January Sales” or “Sales by Months” appear more meaningful, compared to default Excel generated names (PivotTable1 and PivotTable2)

Another advantage of changing the default Names of Pivot Tables is that you will be able to reference them in formulas and in Visual basic coding.

Steps to Change Pivot Table Name

As mentioned above, it is really easy to change Pivot Table name in Microsoft Excel.

1. Right-click anywhere on the Pivot Table and then click on PivotTable Options… in the menu that appears.

PivotTable Options Tab

2. On Pivot Table Options screen, click in the box next to PivotTable Name and type the New Name for your Pivot Table. In our case, we have named our Pivot Table as “January Sales by Store”.

Change Pivot Table Name

3. Once you are done, click on the OK button to save this change.

Related
  • How to Add or Remove Subtotals in Pivot Table

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved