Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Create a Dropdown List in Excel
A dropdown list helps people pick from approved options and reduces typos. In Excel, you usually build one with Data Validation pointing at a range or a table column.
What you need first
Decide where the allowed values will live (a hidden column is fine) and which cell should show the dropdown (often a single cell or a whole column of cells).
Create a simple dropdown from a range
- Select the cell(s) where you want the dropdown.
- Go to Data → Data Validation (sometimes labeled Data Validation…).
- Under Allow, choose List.
- For Source, select the range that contains your list values, or type values separated by commas (for short static lists).
- Click OK.
Use a Table so new rows auto-expand the list
- Put your list in a column and convert it to a Table (Insert → Table).
- In Data Validation, set the source to the table column (Excel will use a structured reference like
Table1[Column1]). - When you add items at the bottom of the table column, the dropdown updates automatically.
Optional: named ranges
For cleaner formulas, define a Named Range for your list and use =YourName as the Data Validation source.
Try it faster with guidance
Skip hunting through ribbons and menus—let Vocordia guide you through it with voice and on-screen cursor guidance so you can finish the steps without tab-switching.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.