• Home

  • Productivity

  • App tips

App tips

5 min read

How to add a dropdown list in Google Sheets

By Jessica Lau · September 10, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

So you're trying to keep heaps of data organized and correctly formatted in one spreadsheet with multiple collaborators—what could possibly go wrong?

Yeah.

If you use Google Sheets to manage your data, there are some features that can help with data consistency and accuracy. One of those features: dropdown lists.

An in-cell dropdown includes a list of values, such as numbers or categories, which you can select from to add or organize data. You can create a dropdown list in Google Sheets by entering preset values or using existing data. I'll walk through how to add a dropdown list using both methods so you can add more clarity and categorization to your spreadsheets.

If you're just looking for a cheat sheet, here's the short version of how to add a dropdown list in Google Sheets. (Keep scrolling for a more detailed breakdown.) 

  1. Select the cell or cells where you'd like to add a dropdown list.

  2. In the top menu bar, click Data, then select Data validation. Or you can right-click your desired cell and select Dropdown.

  3. Choose the criteria for your dropdown menu, and add your options.

  • How to create a dropdown list with preset values

  • How to create a dropdown list using existing data

  • How to edit or remove a dropdown list

  • How to use your new dropdown list

  • Why add a dropdown list in Google Sheets?

  • Google Sheets dropdown list FAQ

  • Automate Google Sheets

How to create and add a dropdown list in Google Sheets with preset values

Let's say you use Google Sheets to track lead data, like names and locations. In this example, your leads are based only in four locations: New York, Los Angeles, Chicago, and Houston. You can add a dropdown list with only these cities, making it that much faster to keep track of everyone. 

  1. Open your spreadsheet. 

  2. Select the cell or cells where you'd like to add a dropdown menu. In the example below, I want to add a dropdown list beside each lead to capture their location. 

    Selecting a cell in Google Sheets to add a dropdown list.
  3. In the top menu bar, click Data. Then select Data validation

    How to add data validation in Google Sheets.

    Alternatively, you can right-click the cell you want to add a dropdown to and select Dropdown

    Dropdown menu when you right-click a cell in Google Sheets.
  4. In the Data validation rules panel, enter your dropdown options as separate values and assign each one a unique color. To add more options to your list, click Add another item

    Creating the data validation rules for a dropdown list in Google Sheets.
  5. Click Done.

Now, in those cells, you'll only be able to select from one of the options in the dropdown list—Google Sheets won't let you type anything "invalid" in there. That's why they call it data validation.

Demo of trying to enter an invalid value in a cell with a dropdown list.

How to create and add a dropdown list in Google Sheets with existing data

Let's say you already entered the options you want to use for your dropdown directly in your spreadsheet. Here's the easiest way to create a dropdown list in Google Sheets with those existing values. 

  1. Select the cells with the values you want to include in your dropdown list. 

  2. Right-click your highlighted cells, and then select Dropdown.

How to add a dropdown list in Google Sheets using existing data.

The value of the cells you highlighted will automatically populate as unique dropdown options in the Data validation rules panel. By default, each option is assigned a light gray color. I recommend changing this to make it easier to distinguish between each option. 

Adding the criteria for a dropdown list in Google Sheets.

Once you've modified your options, click Done.

How to edit or remove a dropdown list in Google Sheets

Editing a dropdown list is just as straightforward as creating one. 

  1. Click the cell with the dropdown that needs to be updated. 

  2. Click the Edit icon, which looks like a pencil. 

    How to edit a dropdown list in Google Sheets.
  3. In the Data validation rules panel, make your changes to the dropdown list. To delete the dropdown entirely, click Remove rule

  4. Click Done.

How to use your new dropdown list

Using a dropdown list in Google Sheets isn't data science (though it can help with it). Just click the arrow that populates next to the shaded bubble in the cell with your list, and choose an option to populate the cell.

A cell in Google Sheets with a dropdown list option selected.

More often than not, you'll want to use your dropdown list for an entire row or column of cells. To do this, you can either drag the bottom-right corner of the cell with your dropdown menu to the cells you want to populate with the same list, or copy and paste the contents of the cell into other cells.

A dropdown list in select cells of a Google Sheet.

Why add a dropdown list in Google Sheets?

You can select an option from a dropdown list without doing any typing, which reduces the likelihood of entering a typo or incorrect info. If you like being at the mercy of human error, I can't stop you, but I will cringe.

And it's not just about accuracy—it also saves time, especially if you're collaborating on a sheet and want to ensure everyone involved has access to the same inputs.

Plus, it opens up a lot more options for how you can put Google Sheets to use. You can use dropdown lists to create forms for things like data collection, inventory and project management, surveys, time tracking, and expense reports. They'll be easier to create—and a lot prettier.

Google Sheets dropdown list FAQ

Looking for more tips on using Google Sheets dropdown lists? Turns out there's a decent amount of nuance to these tiny things.

How do I create a dropdown list in Google Sheets with multiple selections?

To allow multiple selections in your dropdown lists, go to Data > Data validation > Add rule, and select Allow multiple selections

How do I add categories to a dropdown list in Google Sheets?

If you need more categories in a dropdown list, go to Data > Data validation, select the rule associated with your list, then click Add another item

Screenshot showing how to add categories to a dropdown list in Google Sheets

How do I autofill a dropdown list in Google Sheets?

To autofill a dropdown list, select the range of cells with the values you want to include in your list. Right-click the cells and select Dropdown. You can see a step-by-step guide with screenshots here.

Automate Google Sheets

Dropdown lists are just one way to reduce the chance of human error in Google Sheets. Another tactic: automate data entry. Use Zapier to connect Google Sheets to your other apps, so you can automatically import lead data, form submissions, or anything else from your tech stack. Learn more about how to automate Google Sheets, or get started with one of these pre-built workflows.

Save new Gmail emails matching certain traits to a Google Spreadsheet

Save new Gmail emails matching certain traits to a Google Spreadsheet
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets
  • Facebook Lead Ads logo
  • Google Sheets logo
Facebook Lead Ads + Google Sheets

Send emails via Gmail when Google Sheets rows are updated

Send emails via Gmail when Google Sheets rows are updated
  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Create Google Sheets rows for new Google Ads leads

Create Google Sheets rows for new Google Ads leads
  • Google Ads logo
  • Google Sheets logo
Google Ads + Google Sheets

Zapier is the leader in workflow automation—integrating with thousands of apps from partners like Google, Salesforce, and Microsoft. Use interfaces, data tables, and logic to build secure, automated systems for your business-critical workflows across your organization's technology stack. Learn more.

Related reading:

  • How to freeze columns in Google Sheets

  • 21 free Google Sheets templates to boost productivity

  • How to merge cells in Google Sheets

  • How to sort in Google Sheets

  • How to wrap text in Google Sheets

This article was originally published in March 2023 by Luke Strauss. The most recent update, with contributions from Dylan Reber, was in September 2024.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'