1. Extensions
  2. Excel Add-in Series 3
  3. Work with Anaplan model data in Excel
  4. Insert columns and rows on a worksheet

In series 3 of the Excel Add-in, you can insert new columns and rows on an Excel worksheet that is connected to Anaplan. This is useful if you want to perform additional calculations on the data, or add data from another source.

If you want to enter new data, create a new row or column.

If you insert new columns and rows on a worksheet, they are preserved when you refresh the connection with Anaplan.

Note: If you copy and paste Anaplan data to elsewhere in the worksheet, so that it no longer falls under the Anaplan column and row headers, the data will not be refreshed when you refresh the add-in.

To insert a new column:

  1. Right-click the column heading to the right of where you want the new column to be.
    A context menu displays.
A worksheet with a context menu displayed. Insert is highlighted.
  1. Click Insert.
    A new column displays to the left of the selected column.

To insert a new row:

  1. Right-click the row heading below where you want the new row to be.
    A context menu displays.
A worksheet with a context menu displayed. Insert is highlighted.
  1. Click Insert.
    A new row displays above the selected row.