A drop-down list is a cell data entry aid which provides a list of a pre-defined values from which the user can select the value to use.


The user can only use values in the provided list as values for the cell.


A drop-down list is created using the values in a range of cells. The Validation command of the Data menu item is used to create drop-down lists - using "List" as the Settings tab Allow parameter.