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.

Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.