Inserting rows and columns

To insert a row or column in a pivot table:

  1. Activate the table.
  2. Select any cell in the table.
  3. From the menus, choose:

    Insert Before


    Insert After

    From the submenu, choose:




  • A plus sign (+) is inserted in each cell of the new row or column to prevent the new row or column from being automatically hidden because it is empty.
  • In a table with nested or layered dimensions, a column or row is inserted at every corresponding dimension level.

Note: This feature is not available in legacy tables.