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:
=CHOOSE(2, "5423690091", "Q1 FY16")
When you refresh your connection, all cells go back to to their value in the Anaplan source model. This includes column and row headers.
Alternatively, to create headers that persist on refresh:
If the Anaplan source data gains or loses columns or rows, headers created with this method become offset.
We update Anapedia content regularly to provide the most up-to-date instructions.