Drop-Down List

Drop-Down List helps you create selectable menus in cells for entering fixed-option data. It provides the tools you need to reduce manual input errors and improve data entry efficiency, making your work more efficient and helping you accomplish tasks with ease. With Drop-Down List, you can add options manually, import options from an existing cell range, reorder or delete options, and create lists through data validation by entering comma-separated values. Imported cell-based options can update automatically when the source range changes, and named ranges can support global updates for reused lists. Whether you're entering standardized values, maintaining frequently updated option sets, or troubleshooting abnormal option display caused by duplicates, Drop-Down List helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53