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

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.

You can rename any columns and rows that you've manually inserted into a worksheet by clicking on the header cell and typing the new name. However, if you want to rename a row or column that has been imported from Anaplan, you must edit the value using the Google Sheets formula bar.

The Google Sheets formula bar displays a formula that has the syntax:

=CHOOSE("Value1", "Value2", "Value3", "Value4")

Value4 represents the column or row name. Only edit this value.

For example, suppose you have a sales sheet that uses a Products list for the rows. You might want to update the name of one of the products from Gold Collection to Platinum Collection.

A Google Sheet with the header cell of a row selected. The formula for the cell displays in the formula bar at the top of the worksheet.

When you select the cell for Gold Collection, the following formula displays:

=CHOOSE(3, "101000000003", "206000000002", "Gold Collection")

Gold Collection is the value between the final set of quotation marks. To rename the row header, replace Gold Collection with Platinum Collection.

Remember: when you edit the formula for a header name imported from Anaplan, you must change only the name (the value in the last set of quotation marks). The rest of the formula retrieves data from Anaplan when you refresh the connection.

If you cannot see the Google Sheets formula bar, contact your IT department. It may be hidden due to your company IT picy. The Anaplan Google Sheets Add-in does not disable the formula bar. 

To rename a column or row that has been imported from Anaplan:

  1. Click the row or column header you want to rename.
  2. Edit the column or row name between the last set of speech marks.
    In the example above, you would overwrite the row name Gold Collection.
  3. Press Enter.
    The header updates.