Change Pivot Desk Title

It's very easy to alter Pivot Desk Title in Microsoft Excel. You will discover under the steps to alter the title of a Pivot Desk, together with related screenshots.

Change Pivot Desk Title

Whenever you create a Pivot Desk, Microsoft Excel mechanically names the Pivot Desk as PivotTable1 and the following Pivot Desk that you simply create is known as as PivotTable2.

As a substitute of following this default naming conference, you may change Pivot Desk Title to one thing significant and related to the information on the Pivot Desk.

For instance, Pivot Tables with names “January Gross sales” or “Gross sales by Months” seem extra significant, in comparison with default Excel generated names (PivotTable1 and PivotTable2)

One other benefit of adjusting the default Names of Pivot Tables is that it is possible for you to to reference them in formulation and in Visible fundamental coding.

Steps to Change Pivot Desk Title

As talked about above, it's very easy to alter Pivot Desk title in Microsoft Excel.

1. Proper-click anyplace on the Pivot Desk after which click on on PivotTable Choices… within the menu that seems.

2. On Pivot Desk Choices display screen, click on within the field subsequent to PivotTable Title and sort the New Title in your Pivot Desk. In our case, we have now named our Pivot Desk as “January Gross sales by Retailer”.

3. As soon as you're carried out, click on on the OK button to avoid wasting this variation.

• Add or Take away Subtotals in Pivot Desk