✦Template Printable Ideas Insights

How to Add Dropdown Values in Google Sheets

By

Need to create dynamic lists in Google Sheets? Dropdowns are a fantastic way to keep your data organized and streamlined. They allow you to select values from a list instead of typing them manually, reducing errors and speeding up data entry. Here's a step-by-step guide to add dropdown values in Google Sheets for better data control and efficiency.

Before we dive in, ensure you've enabled editing in your Google Sheet. If editing is restricted, click on the 'Share' button at the top right, then 'Advanced', and make sure 'Who has access' is set to 'Anyone with the link can edit'.

Understanding Data Validation vs. Dropdowns

Before we start, it's crucial to understand the difference between Data Validation and Dropdowns. Data Validation allows you to set rules for data entry, while Dropdowns create a list of options to choose from. Dropdowns are a part of Data Validation's capabilities. We'll focus on creating Dropdowns within Data Validation.

Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Google Sheets Data Validation – How to create dependent drop down list in Google Sheets
Google Sheets Data Validation – How to create dependent drop down list in Google Sheets
How to Get the Absolute Value in Google Sheets
How to Get the Absolute Value in Google Sheets

For this tutorial, let's assume you have a Google Sheet with a heading 'Fruit' where you want to add a Dropdown for choosing from a list of fruits: Apple, Banana, Cherry, Date, Elderberry.

Creating a Dropdown List

First, create your dropdown list. In a separate sheet or a unused range in the same sheet (e.g., B1:B6), type your options: Apple, Banana, Cherry, Date, Elderberry. This range will be your data source for the Dropdown.

📊 Color Coded Dropdowns in Google Sheets
📊 Color Coded Dropdowns in Google Sheets
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
an image with the words dynamic independent dropdown list and google sheets in green text
an image with the words dynamic independent dropdown list and google sheets in green text

Position your cursor in the cell where you want the Dropdown, for example, cell C1. Now, follow these steps:

Adding a Dropdown to a Cell

1. Click on the 'Data' menu at the top of your Google Sheet, then click on 'Data Validation'.

2. In the 'Lists' tab that appears on the right, under 'Sources', select 'List of items'.

How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier
How to Add a Drop-Down List in Google Sheets and Excel - Make Tech Easier
Master Google Sheets Dynamic Named Ranges
Master Google Sheets Dynamic Named Ranges
How to Add a Drop Down List in Google Sheets (Step-by-Step)
How to Add a Drop Down List in Google Sheets (Step-by-Step)
Smart Data Validation. Create Dependent Drop-Down Lists in Google Sheets
Smart Data Validation. Create Dependent Drop-Down Lists in Google Sheets
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
10 Essential Google Sheets Formulas Everyone Should Know
10 Essential Google Sheets Formulas Everyone Should Know

3. In the 'List items' box, click on the dropdown icon (') and select the range containing your list (B1:B6 in our example).

4. Choose the 'On input' behavior. We recommend 'Revalidate', which updates the Dropdown every time you click on the cell.

5. Click 'Save' in the bottom right corner.

6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know
the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages
Google Sheets Apps Script - Dynamic Dependent Dropdown Data Validation Lists - Chicago Computer Classes
Google Sheets Apps Script - Dynamic Dependent Dropdown Data Validation Lists - Chicago Computer Classes

Now, when you click on cell C1, you'll see a Dropdown arrow. Clicking this arrow reveals the list of fruits you've created. Selecting an item from the list populates the cell with the chosen fruit.

Updating and Managing Dropdowns

Making changes to your Dropdown list is straightforward. Just update the range containing the Dropdown list (B1:B6), and the Dropdown in cell C1 updates automatically with the new options.

To remove or reset the Dropdown from a cell, click on the cell, then click on 'Data Validation' in the menu. Click 'Under input' in the dropdown (may also be named 'Clear'), and click 'Save'.

Creating a Dropdown with Multiple Choices

You can also create Dropdowns that allow for multiple choices. To do this, in the 'Data Validation' settings, check the box 'Allow multiple selections'. The Dropdown menu will then allow you to select more than one item, and the cell will display all chosen items in a list.

In conclusion, mastering how to add dropdown values in Google Sheets is a powerful tool in managing and organizing your data. With a little practice, you'll find yourself using Dropdowns regularly to keep your Google Sheets clean, organized, and efficient. Happy data managing!