English
  • English
  • 日本語
  1. Extensions Extensions
  2. Excel Add-in Series 4 Excel Add-in Series 4
  3. Rename columns or rows in a worksheet Rename columns or rows in a worksheet

Excel Add-in Series 4

  1. Before you download or upgrade the Excel Add-in
  2. New to the Excel Add-in: Download and Install
  3. Install via the command line
  4. Proxy settings
  5. Upgrade the Excel Add-in
  6. Enable or disable the Excel Add-in
  7. The Anaplan ribbon
  8. Sign In with your Anaplan username and password
  9. Use Single Sign-on (SSO)
  10. Sign In with Authentication Settings
  11. Sign Out of the Excel Add-in
  12. Add Authentication Settings
    1. Find a Connection URL
    2. Find your SSO Friendly URL
  13. Delete Authentication Settings
  14. Settings
  15. Connections
    1. New Read-Only Connection to a module
    2. New Read-Only Connection to a saved view
    3. New Read/Write Connection to a module
    4. New Read/Write Connection to a saved view
    5. Multi-Sheet Connection
    6. Sync Sheets
    7. Clone
    8. Remap
    9. Refresh
  16. Workbook Conversion
  17. Data impacts of Refresh
  18. Send and Refresh
  19. Troubleshoot Send and Refresh
  20. Pivot and Filter
  21. Preview
  22. Rename columns or rows in a worksheet
  23. Show or Hide Toolbar
  24. FAQs

Rename columns or rows in a worksheet

You can rename columns and rows via the Excel formula bar.

To rename a column or row in a worksheet:

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

© 2021 Anaplan, Inc. All rights reserved.

  • Privacy policy
  • Terms of service