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

   or

   Insert After

   From the submenu, choose:

   Row

   or

   Column

• 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.