1. Extensions
  2. Google Sheets Add-on
  3. View and edit Anaplan data in Google Sheets
  4. Insert columns and rows in a worksheet

You can insert new columns and rows on a worksheet that has a connection to Anaplan. This is useful if you want to perform additional calculations on the data, or add data from another source.

The Google Sheets Add-on is in early access (EA), and is only available to participants of the EA program.

Find out more about early access or how to register your interest in our current EA programs.

It is important to create a new row or column if you want to enter new data. Any new columns and rows you insert on a worksheet are preserved when you refresh the connection with Anaplan.

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.

Some grids use nested dimensions instead of page selectors. Be aware that if you insert new column headers between nested row headers (or new row headers between nested column headers) this will break the connection.

A Google Sheets worksheet displaying data from an Anaplan module that uses nested dimensions. A context menu has been opened for the column where the second level dimensions are. The cursor hovers over the Insert 1 left menu option.

If you need to insert new column headers within nested headers, insert them in Anaplan, then refresh the connection.

To insert a new column:

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

To insert a new row:

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