{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Multi-select drop down ","Without duplicates","Item removal","Custom delimiter","Selections in separate lines"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,2]]}
[]
[]
[]
[null,"Excel Dropdown List with Multiple Selections"]
[]
[null,"The workbook shows how to create an Excel drop down that allows users to select multiple items with or without duplicates. "]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-06-29"]
[null,"Tutorial URL","How to make Excel drop down list with multiple selections"]
[]
[null,"Examples:"]
["• ","Excel multi-select drop down (with repeated items)"]
["• ","Multi-select drop down without duplicates "]
["• ","Multi-selection dropdown with item removal "]
["• ","Multiple selection dropdown with custom delimiter "]
["• ","Multiple selections in separate lines "]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Multi-select drop down ","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,2,1,3]]}
["Multi-select drop down with repeated items"]
["Items",null,"Choose the ingredients"]
["Apricot",null,"Appetizer","Eggs, Cheese, Bread crumbs"]
["Bread crumbs",null,"Salad","Celery, Cucumber, Onion, Olive oil"]
["Broth",null,"Soup","Broth, Milk, Pumpkin"]
["Butter",null,"Main dish","Chicken, Butter, Flour, Pepper, Salt"]
["Carrot",null,"Dessert","Chocolate, Cinnamon, Chocolate, Chicken, Eggs"]
["Celery"]
["Cheese"]
["Chicken"]
["Chocolate"]
["Cinnamon"]
["Cucumber"]
["Eggs"]
["Flour"]
["Garlic"]
["Milk"]
["Nuts"]
["Olive oil"]
["Onion"]
["Pepper"]
["Pumpkin"]
["Salt"]
["Sugar"]
["Tomato"]

{"sheet":"Without duplicates","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,2]]}
[null,"Multi-select drop down without duplicates "]
[null,"Choose the ingredients"]
[null,"Appetizer","Eggs, Cheese, Bread crumbs"]
[]
[null,"Salad","Celery, Cucumber, Onion, Olive oil"]
[]
[null,"Soup","Broth, Milk, Pumpkin"]
[]
[null,"Main dish","Chicken, Butter, Flour, Pepper, Salt"]
[]
[null,"Dessert","Chocolate, Cinnamon, Eggs, Celery"]

{"sheet":"Item removal","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,2]]}
[null,"Multi-selection dropdown with item removal "]
[null,"Multi-select drop down",null,null,">> The first click on an item adds it to the selection; a second click on the same item removes it from the selection."]
[null,"Appetizer","Eggs, Cheese, Bread crumbs"]
[]
[null,"Salad","Celery, Cucumber, Onion, Tomato, Salt, Olive oil"]
[]
[null,"Soup","Broth, Milk, Garlic, Pumpkin, Salt"]
[]
[null,"Main dish","Chicken, Butter, Flour, Pepper, Salt"]
[]
[null,"Dessert","Apricot, Chocolate, Cinnamon"]

{"sheet":"Custom delimiter","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,2]]}
[null,"Multi-select drop down with custom delimiter"]
[null,"Choose one or more items"]
[null,"Appetizer","Eggs | Cheese | Bread crumbs"]
[]
[null,"Salad","Carrot | Cucumber | Tomato | Olive oil"]
[]
[null,"Main dish","Chicken | Salt | Pepper"]
[]
[null,"Dessert","Chocolate | Milk | Nuts"]

{"sheet":"Selections in separate lines","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,1,0,2]]}
[null,"Dropdown with multiple selections in separate cells"]
[null,"Choose the ingredients"]
[null,"Appetizer","Bread crumbs\r\nEggs\r\nButter"]
[null,"Salad","Carrot\r\nCucumber\r\nTomato\r\nOnion"]
[null,"Soup","Broth\r\nGarlic\r\nMilk\r\nPumpkin"]
[null,"Main dish","Chicken\r\nEggs\r\nFlour"]
[null,"Dessert","Cheese\r\nCinnamon\r\nSugar\r\nChocolate"]