title: Jspreadsheet | Examples | Advanced dropdown column type keywords: Jexcel, jquery, javascript, excel-like, spreadsheet, jquery plugin, sorting, table, grid, order by description: Full examples on how to handle simple, advanced, autocomplete and conditional dropdowns. [Back to Examples](/jspreadsheet/v2/examples) # Working with dropdowns Jspreadsheet brings some new very flexible dropdown options that enables you to delivery great user experience though applications. The new dropdown column options include the autocomplete, multiple options, data picker, different template types and much more advantages, such as: * Create a simple dropdown from array * Value or key-value select is available * Populate a dropdown from a external JSON request * Dynamic autocomplete search based on another column value * Conditional dropdowns: options from a dropdown based on a method return * Multiple and autocomplete * Responsive data picker ## Multiple and autocomplete options The highlight features introduced in the most version of the jquery table is definitely the autocomplete and multiple options. The following example shows the column Product Origin with the autocomplete and multiple directives initiated as true. ### Source code ```html

``` ## Conditional dropdown Jspreadsheet dropdown column can show different options based on the value of other columns. To use that function you should use a method defined by the filter parameter in the initialization. The following example shows the product column options based on the value selected on the column Category. ### Source code ```html

```