1. Extensions
  2. Excel Add-in Series 4
  3. Work with Anaplan model data in Excel
  4. Rename columns or rows

In series 4 of the Excel Add-in, you can rename columns and rows via the Excel formula bar.

To rename a column or row header:

  1. Select the cell for a column header, in this example Q1 FY16.
    The formula for the selected cell displays. In this case:
    =CHOOSE(2, "5423690091", "Q1 FY16")
  2. Change the value within the last set of quotation marks.
    The header name changes as you type.
Rename a column header in a worksheet.

When you refresh your connection, all cells revert to their value in the Anaplan source model. This includes column and row headers.

Alternatively, to create headers that persist on refresh:

  1. Add new columns or rows outside of your connection.
  2. Enter names for your new column or row headers outside of your connection.
  3. Hide the row or column headers in your Anaplan connection.

Note that if the Anaplan source data gains or loses columns or rows, headers created with this method become offset.