How to Create a Drop-Down List in Google Sheets

Drop-down lists ensure consistent data entry by limiting choices to predefined options. They are essential for categories, status fields, and any controlled input.

Select Your Cells

Highlight the cells where you want the drop-down list to appear.

Open Data Validation

Go to Data > Data validation. This opens the data validation rules panel.

💡 Data validation also prevents invalid entries.

Choose List from a Range

Select "List from a range" and specify the range containing your list items. Alternatively, choose "List of items" and type items separated by commas.

Configure Display Options

Choose whether to show a warning or reject invalid input. You can also display helper text when the cell is selected.

Try These Templates

Expense Tracker Sales Tracker

Frequently Asked Questions

Can I create a dependent drop-down list?

Yes. Use INDIRECT formulas to create cascading drop-downs where the second list depends on the first selection.

Can I edit the list items later?

Yes. Edit the source range or item list and the drop-down options will update automatically.