title: 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, multiple, autocomplete and conditional dropdowns. Create amazing javascript tables using categories and images in your dropdowns. [Back to Examples](/jspreadsheet/v3/examples "Back to the examples section") # Dropdown and autocomplete column type Jspreadsheet brings a very powerful, reflexive and responsive dropdown column type to support a better user experience through your applications. The new dropdown column options include 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 box 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 selection and internal dropdown search * Responsive data picker with multiple render types * Image icon and group items ## Multiple and autocomplete options The highlight features introduced in the most version of the vanilla javascript spreadsheet is definitely the autocomplete and multiple options. The following example shows the column Product Origin with the autocomplete and multiple directives initiated as true. ```html

``` ## Conditional dropdown The example below shows the dependency of the second column in relation to the first. ```html

``` ## Group, images, and advanced render options Improve the user experience with a responsive data picker. ```html

``` ## JavaScript Dropdown Component More options for the dropdowns, please refer to the [jSuites JavaScript Dropdown Documentation](https://jsuites.net/docs/dropdown).