Excel Dropdown List

EasySQL · PostgreSQL

How would you make a dropdown list in Excel?

Return the valid option labels that should populate the dropdown, then describe how the resulting list would be connected to Excel Data Validation.

Output

One row per valid dropdown option with columns option_label and display_order
Include active, non-null, non-empty options only
Order by display_order ascending, then option_label ascending

dropdown_options

Column	Type	Description
option_idPK	INT	Unique identifier for the dropdown option
option_label	VARCHAR(100)	Text displayed as a dropdown choice
display_order	INT	Preferred position in the dropdown list
is_active	BOOLEAN	Whether the option is currently available

Tablesdropdown_options

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.