Insert XL3Member formulas

You can insert XL3Member formulas directly into the spreadsheet using the Anaplan XL > Insert Formula > Members ribbon or menu option.

To insert members:

1. Select the Anaplan XL > Insert Formula > Members ribbon or menu option.
2. Choose a location for the new formula.
3. Choose the connection to use from the dropdown.
4. Select the hierarchy the desired members belong to.
5. Select the members to insert. 
6. Select OK to insert the formula.

If you want to insert only the captions of the members instead of XL3Member formulas, select the Insert as Text checkbox

If multiple members are selected, you can insert them vertically (Insert down) or horizontally (Insert right).