Insert Dropdown List

Insert Dropdown List helps you create dropdown menus in cells so input is limited to predefined options and data stays consistent. It provides the tools you need to apply existing templates or build custom lists, making data entry more efficient and helping you accomplish tasks with ease. With Insert Dropdown List, you can use preset options such as Yes/No, Not Started/In Progress/Completed, and A/B/C, add, reorder, and delete custom options, enable single-select or multi-select, assign colors to options, and update other cells using the same dropdown list. You can also set options by manual entry or referenced cell ranges, ignore blank values, configure validation warnings for invalid input, and remove dropdown lists without clearing existing cell content. Choose the documentation below that best matches your needs to learn more.

1:53