Option to allow multiple selection in data validation

Option to allow multiple selection in data validation

Posted by: dpandey on 25 May 2026, 6:31 am EST

• 

  dpandey

  • Post Options:
  • Link
    Copy

  Posted 25 May 2026, 6:31 am EST - Updated 25 May 2026, 7:08 am EST

  Hi there,
  
  Currently when we apply data validation to any cell … and allow a list in data validation… which gives a dropdown to select values on the applied cells.
  
  But currently , there is no option present to allow multiple selections from the dropdown as present in google sheets.

  Attaching both screen recordings for reference,

  

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 2 June 2026, 2:00 am EST

  Hi Deepak,

  Apologies for the delay caused, and thank you for sharing the recordings.

  Currently, SpreadJS Data Validation lists do not provide a built-in option for selecting multiple items from the dropdown. However, this behavior can be achieved through customization.

  One possible approach is to use a Cell Dropdown with the multiSelect option enabled and handle the EditEnding event to validate and sanitize the selected values. This allows users to select multiple items from the dropdown while ensuring that only valid values are retained in the cell.

  Please refer to the sample project that demonstrates this implementation - MultiSelectDropdown.

  Please note that this is a custom solution rather than a built-in Data Validation feature, so you may further adapt the implementation to suit your application’s requirements.

  Please review the sample and let us know if you have any questions or need any further assistance.

  Kind Regards,
  
  Chirag