How to Create a
Drop-Down List in
Google Sheets
Select the cell or range where you want the drop-down list to appear.
Click Data in the top menu and choose Data validation.
Under Criteria, select List of items and enter the options separated by commas (e.g., Yes, No, Maybe).
Alternatively, select List from a range to pull the drop-down options from another sheet or column.
Check the box for Show dropdown list in cell and click Save to apply the drop-down.
Click the arrow in the cell to test the drop-down and select a value.
