• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Gadgets

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

Primary Sidebar

Twitter
Facebook

Popular Now

  • How to Boot Windows 10 From USB Drive
  • How to Backup iPhone to iCloud
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Setup Chromecast on Android and iPhone

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 2020 @Techbout.com · All Rights Reserved