Stockertim Dictionary · Technology
Drop-down list
Also called drop-down lists, dropdown list, pick list, list validation
In short
A data validation setting that limits a cell to values chosen from a fixed list, which stops misspellings and inconsistent labels at the point of entry.
- Beginner
- Technology
- Checked
In detail
A drop-down list adds a small arrow to a cell; clicking it shows the allowed entries, and the user picks one. In Excel it is set up through Data validation with the List option, with the choices either typed in, separated by commas, or taken from a range of cells elsewhere in the workbook. A range is easier to maintain, especially when it is a formatted table that grows as new options are added.
The point is consistency. A region column filled by hand soon holds North, north, Nth and North with a trailing space, which conditional sums and pivot tables treat as four different regions. A list with one approved spelling of each value keeps totals whole and makes later cleaning unnecessary. Lists suit any field with a known set of answers: department, status, currency, category or yes and no.
Validation can also warn rather than block. The error alert has three styles: Stop refuses entries not on the list, Warning lets the user override after a prompt, and Information only shows a message. An input message can explain what to choose. Dependent lists, where the second choice depends on the first, such as city after country, are possible with named ranges.
The protection is incomplete. Pasting data into a validated cell replaces the validation rather than being checked by it, and values entered before the list was set up are not tested. Spreadsheet programs offer a command that circles invalid entries, which is worth running on shared sheets from time to time.
Worked example
An NGO in Kisumu tracks field expenses by category. Before the change, the category column held 14 spellings of its 5 real categories.
- A drop-down list with the 5 approved categories is applied to the column
- New entries can only be one of the 5, so a pivot of spending shows 5 rows instead of 14
Totals by category are complete without any manual cleaning.
In practice
Shared trackers, timesheets, expense claims, risk registers and survey sheets use drop-down lists for every field with a fixed set of answers, often with the lists kept on a separate, protected sheet.
Watch out
- Pasted values bypass the list; check shared sheets for invalid entries.
- A typed list inside the rule is harder to update than a list kept in cells.
Learn it properly
Official sources
- The Government Data Quality Framework · UK Government Data Quality Hub
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.