Trusted Reviews is supported by its audience. If you purchase through links on our site, we may earn a commission. Learn more.

How to create a drop-down list in Google Sheets

Struggling to gather all of your information in Google Sheets? Try creating a drop-down menu to display all of your statistics concisely.

Google Sheets allows you to create spreadsheets directly in your browser and comes with a lot of handy features. One of the best features of Google Sheets is the ability to add drop-down menus, to make organising your work even easier. 

If you want to learn how to create and edit a drop-down menu in Google Sheets, keep reading, as we’re going to be running through the process with a simple step-by-step guide. 

S23 Ultra and Galaxy Chromebook Go Bundle

S23 Ultra and Galaxy Chromebook Go Bundle

Samsung fans can nab an S23 Ultra with a Galaxy Chromebook Go for a seriously reduced price with this incredible bundle.

  • Amazon
  • Was £1698
  • Now £1249
View Deal

What you’ll need: 

  • A Google Account
  • Google Sheets

The Short Version 

  • Open a new spreadsheet in Google Sheets
  • Select the cells where you want to create a drop-down list
  • Click Insert
  • Go to Drop-down
  • Add another item if needed
  • Label all the items
  • Add colours if needed
  • Click Advanced options
  • Select all options you require
  • Click Done
  • Insert your drop-down menu labels
  1. Step

    Open a new spreadsheet

    Open a new Google Sheets spreadsheet on your PC. Open Google Sheets

  2. Step

    Select the cells where you want to create a drop-down list

    Select all the cells where you want to create a drop-down list by clicking and dragging over them.Select the cells

  3. Step

    Click Insert

    From the menu at the top of the screen, click Insert.Click Insert

  4. Step

    Go to Drop-down

    Select Drop-down from the menu. Go to drop-down

  5. Step

    Add another item if needed

    If you need to add more items in your drop-down menu, click on Add another item.Add in more options

  6. Step

    Label all the items

    Label all of your drop-down items. Name all the options

  7. Step

    Add colours if needed

    If you want to add colours to all your drop-down menu items, select them now. Select all colours

  8. Step

    Click Advanced options

    Click on Advanced options. Advanced options

  9. Step

    Select all options you require

    Select any options in this section that you require for your drop-down menu.Click Done

  10. Step

    Click Done

    Once you are happy with your drop-down menu, click Done. Click Done

  11. Step

    Insert your drop-down menu

    Insert your drop-down menu items.Enter an option


Can I change my Google Sheets drop-down menu after it’s been created?

Yes, you can edit your drop-down menu at any time once it has been created.

Can I delete a Google Sheets drop-down menu?

Yes, you can delete a drop-down menu created in Google Sheets if you need to.

Why trust our journalism?

Founded in 2003, Trusted Reviews exists to give our readers thorough, unbiased and independent advice on what to buy.

Today, we have millions of users a month from around the world, and assess more than 1,000 products a year.

author icon

Editorial independence

Editorial independence means being able to give an unbiased verdict about a product or company, with the avoidance of conflicts of interest. To ensure this is possible, every member of the editorial staff follows a clear code of conduct.

author icon

Professional conduct

We also expect our journalists to follow clear ethical standards in their work. Our staff members must strive for honesty and accuracy in everything they do. We follow the IPSO Editors’ code of practice to underpin these standards.