Edit an existing pivot table

Edit an existing pivot table

To edit a pivot table:

    1. Right click on the pivot table to be edited.

    2. Select Builder.

    3. Make the desired changes and click Generate.

Alternatively, move your selection to the Pivot table. Click on the contextual pivot table side pane, and edit the table.


    • Related Articles

    • Move a pivot table across sheets

      To move a pivot table: 1. Right click on the pivot table to be moved. 2. Select Move from the contextual menu. 3. Choose the destination sheet i.e. new sheet or an existing sheet and click OK. You can also use the side panel context menu, Custom > ...

    • Delete a pivot table

      To delete a pivot table: Right click on the pivot table and click Delete, or select the table and go to Custom > Delete in the Pivot Table context menu on the right.

    • Change the style of a pivot table

      To change the style of a pivot table: 1. Click on the pivot table. 2. The Pivot Table context menu opens on the right. 3. Select the desired Table Styles, Color Schemes and click Generate.

    • Create a pivot table in sheet

      To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created. Drag and drop the fields into the desired positions in the Pivot Table Builder and click ...

    • View the subtotal of the data in a pivot table

      To view the total: 1. Click on the pivot table. 2. Go to Custom in the contextual menu on the right. 3. Turn on/off the Subtotal, Column Grand Total and Row Grand Total as per your necessity.