How to Create a Drop-Down List in a Cell
Beginner
How-To · Excel
Restrict a cell to a fixed set of choices using Data Validation — useful for status fields, categories, and forms.
- Type your list of allowed options somewhere in the sheet (or a separate sheet), one per cell in a single column.
- Select the cell(s) where you want the drop-down to appear.
- Go to Data > Data Validation > and under Allow, choose "List."
- For Source, either select the range where you typed your options, or type them directly separated by commas (e.g. Yes,No,Maybe).
- Check "In-cell dropdown" is ticked, then click OK — an arrow will appear when you click the cell.
- To update the list later, just edit the source cells if you referenced a range — the drop-down updates automatically.
Running into an error instead of just needing the how-to? Check our Excel troubleshooting guides or the error lookup.
Frequently Asked Questions
Can other people edit the list of options in my dropdown?
Only if you share the workbook without protecting the sheet — for a locked-down dropdown, protect the sheet or workbook after setting it up, allowing only the dropdown cell itself to remain editable.
What happens if someone types something not on the list?
By default, Excel shows a warning and won't accept it — though you can adjust Data Validation settings to show a warning but still allow it, if that flexibility is useful for your specific use case.
More Excel how-tos
How to Build a Simple Budget Spreadsheet
Set up a working monthly budget with income, expenses, and an automatic running total.
How to Pull Data From Another Sheet With XLOOKUP
Look up a value in one table and pull back matching information from another — the modern replacement for VLOOKUP.
How to Build a Pivot Table From Scratch
Summarize a large dataset into totals, averages, and counts without writing a single formula.