If you're using Anaplan XL and the offline data entry mode, you can add validation rules to limit the values allowed.

 You can set up hard and soft validation rules from the Anaplan XL > Options > Workbook Options menu item:

    • A hard validation rule prevents from saving invalid changes to the database
    • A soft validation rule alerts the user but lets them decide whether the changed values should be saved

Whatever its type, a validation rule is based on a Boolean cell and a message. Data entry can only be saved when the value of the Boolean cell returns TRUE.