How to create drop-down lists in Google Sheets

Written on April 14, 2021

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.

Stay in touch

Thanks for reading this article. I'd love to stay in touch and share more tips on programming and side projects with you. Sign up and I'll send you my articles straight to your email, you'll also get a free copy of the light themed version of my Git cheat sheet.
Git cheat sheet preview image