How to create drop-down lists in Google Sheets

Drop-down lists in Google Sheets are helpful to have because it can include a predetermined set of values.

This is helpful in scenarios where you might designate a cell to indicate a type of category or to communicate status for a line item.

Create a drop-down list

1. Select a cell in Google Sheets where you want to create a drop-down list.
2. Select Data > Data validation from the menu
3. For the section that says Criteria select List of items from the drop-down.
   • Alternatively, you could select List from a range if you rather use existing cells to fill your list.
4. In the field next to the drop-down where you selected List of items, enter the items you’d like in your list separated by a comma , and without spaces.
   • For example:
     • Todo,In Progress,Done
     • Small,Medium,Large
5. Hit the Save button and you should now see a little down arrow in the bottom right hand corner of your cell.
   • Clicking on the arrow will show you the options of your drop-down.