Add a Dropdown in Google Sheets: Step-by-Step Guide

To add a dropdown in Google Sheets in a web browser, select the cell or cells, choose Insert > Dropdown, add the choices in the rule panel, and click Done. You can also use Data > Data validation to create a dropdown, including one whose choices come from a range of cells.

What a Google Sheets dropdown does

A dropdown lets someone choose from a defined set of values rather than typing a response from scratch. It can make a task tracker, survey, inventory sheet, or shared report easier to fill out consistently. For example, a task column might offer Not started, In progress, and Done. Without a dropdown, people might enter variations such as finished, complete, or done, making later sorting and counting less reliable.

In Sheets, the dropdown is created by a data validation rule attached to one or more cells. The rule defines the permitted choices and what happens if someone enters a value that is not on the list. A dropdown is not a formula, and it does not automatically perform an action when a choice is made. It controls the cell’s allowed or suggested input; other features, such as conditional formatting, can respond to that input separately.

Create a dropdown with custom choices

Use custom choices when the options are short and unlikely to change often. In a browser, follow these steps:

Select the cell or range where people should make a choice. To apply the same rule to a whole column section, select that range first, such as C2:C100.
Choose Insert > Dropdown. Alternatively, open Data > Data validation and add a rule.
In the rule panel, choose the dropdown criterion if it is not already selected. Add each option as a separate item, and edit the suggested colors if they are useful.
Review the rule’s behavior and display style, then click Done.

Each cell with the rule will show a dropdown control when selected. Click it and choose an option to fill the cell. You can also begin typing a choice to locate a matching option in the menu, depending on the interface and list. Applying the rule to a range at once is usually more efficient than setting up each cell individually.

Choose custom items or a range of cells

There are two useful ways to define the choices. A custom dropdown stores the entries in the rule itself. This is convenient for a small, stable list such as Yes and No, or Low, Medium, and High. It keeps the setup compact, but changing the list later means editing the rule.

A dropdown based on a range uses values already entered in the spreadsheet. For example, place Open, In progress, and Closed in A2:A4 on a sheet named Lists. Select the destination cells, open Insert > Dropdown or Data > Data validation, and set the dropdown criterion to use a range. Enter or select the source range, such as Lists!A2:A4, and save the rule. If the sheet name includes spaces, the reference generally needs single quotes around the name, as in ‘Status options’!A2:A4.

Using a source range is useful when several columns need the same choices or when an owner maintains the list in one place. Updating a source entry can update the option shown in dropdowns that refer to that range. Keep the source list tidy: avoid unintended blanks, duplicate entries, or explanatory notes mixed into the range. A separate sheet can keep reference values out of the way of the working data, though it remains part of the same spreadsheet.

Set validation and display behavior

A dropdown rule can do more than display options. Its invalid-data setting determines whether a person may enter a value outside the list. Choose the rejection option when consistent values matter, such as a status field used for reporting. Choose the warning option when the list is guidance but occasional unlisted entries are acceptable. The exact labels in the panel can change as Google updates the interface, but the distinction is between rejecting an invalid entry and allowing it with a warning.

The display style controls how the dropdown appears in the cell. Depending on the available controls, Sheets offers styles such as a colored chip, an arrow, or plain text. Chips can make statuses stand out visually, while an arrow or plain-text presentation may suit a compact or less colorful sheet. Option colors help readers distinguish categories, but color should not be the only way to communicate meaning; retain clear text labels so the choices remain understandable.

After saving, try selecting a cell and choosing an option. Also test a value that is not on the list if the rule is meant to restrict input. Testing helps confirm both that the intended range has the rule and that the invalid-data behavior matches the sheet’s purpose.

Plan the list for a real spreadsheet

A dropdown works best when each option is clear, distinct, and suited to the decision the person has to make. For a project tracker, a short status list might be Backlog, In progress, Blocked, and Complete. For an equipment log, choices might describe condition, such as Good, Needs repair, and Retired. Avoid overlapping labels such as Nearly done and Almost complete unless users can reliably tell them apart.

Use consistent wording and capitalization so the same meaning is not represented by several entries.
Keep the list short enough to scan. If users need to search through many values, consider whether a source range or a different input method is more practical.
Decide whether an empty cell is a valid state. A blank can mean not yet reviewed, but it can also make a record look incomplete.
Consider who will maintain the choices. A source range is easier to manage when values change or are reused.

For instance, a volunteer sign-up sheet could use a dropdown for shift preference, with Morning, Afternoon, and Evening as options. That is more useful than putting those values in the rule if the coordinator expects shifts to change later: keeping them in a clearly labeled source range makes the edit easier to find. On the other hand, a stable Yes/No field may not need a separate list sheet.

Edit, copy, and remove a dropdown

To change an existing rule, select a cell that uses it and open Data > Data validation. Review the rule in the panel, edit the options or range, and save. If a rule applies to multiple cells, check its applied range before changing or deleting it; otherwise, you may affect more cells than intended. When several rules are present, selecting a cell within the relevant range is a practical way to inspect the rule associated with it.

To apply a dropdown elsewhere, create or extend its applied range in the rule settings. Copying a cell can also carry its validation along with other cell properties, so inspect the destination if you only intended to copy its displayed value. To remove a dropdown, select the affected cell or range, open Data > Data validation, and remove the rule. Removing validation does not necessarily erase the value already stored in the cell; clear the cell’s contents separately if that is what you want.

Common problems and fixes

The dropdown is missing. Confirm that the selected cell is included in the rule’s applied range. The rule may have been added to a different row or column, or removed during editing.
A value is rejected. Check whether the rule is set to reject invalid data and whether the typed value exactly matches one of the permitted options. Extra spaces or a spelling difference can make an entry different from the listed value.
The list is out of date. If the rule uses a source range, update the values in that range and confirm the rule points to the intended cells. If it uses custom items, edit the items in the rule itself.
Choices appear blank or repeated. Inspect the source range for empty cells, duplicate entries, or values that look alike. Clean the source list and verify that the reference starts and ends at the right rows.
Some cells behave differently. A sheet can have different validation rules in different ranges. Check the rule on both a working cell and an affected cell rather than assuming the whole column shares one rule.

One important distinction: a dropdown does not automatically fill neighboring cells, enforce a workflow, or color an entire row. It only supplies or validates a value in the cells covered by its rule. For visual changes based on a selected status, set up a separate conditional-formatting rule. For more complex workflows, consider whether a form, script, or another data-entry method is appropriate, rather than expecting validation alone to manage the process.

Use dropdowns in shared sheets

Dropdowns are especially useful in shared spreadsheets because they make entries more predictable, but they do not prevent every kind of mistake. A collaborator with editing access may be able to change the validation rule or the source list. If only certain people should maintain the choices, explain which cells are inputs and which cells are reference data, and consider protecting ranges where appropriate. Protection controls editing access; it is separate from the dropdown’s validation rule.

Before distributing a template, check the rule on a few rows, test an invalid value, and confirm that the source list is understandable to the people who will maintain it. Include a short instruction near the column heading if users might not know what a choice means. When a sheet is used for analysis, consistent labels make filters, pivot tables, and summaries easier to interpret, but review existing data when adding a rule: validation may not automatically clean up values already entered before the rule existed.

Google Sheets dropdowns versus Excel

Google Sheets dropdowns serve a similar purpose to Excel’s data validation lists, but the menus and terminology differ. In Google Sheets, use Insert > Dropdown or Data > Data validation. In Excel for Microsoft 365 on Windows, a list is typically set up through Data > Data Validation, with the Allow field set to List. Instructions for one program should not be assumed to match the other, and a Google Sheets menu path will not appear in Excel.

For a spreadsheet that will be edited in both services, test how the validation rules behave after conversion or import rather than assuming every setting transfers identically. The basic idea—provide a defined list of allowed or suggested values—is shared, but interface details and supported options can differ.

Frequently Asked Questions

Can I add a dropdown to an entire column?
Select the intended cells in the column, such as B2:B500, before creating the rule, or adjust the rule’s applied range afterward. Using a bounded range can be easier to review than applying a rule to cells that will never be used.

Can a dropdown’s options come from another sheet?
Yes. Set the rule to use a range and select the cells containing the options, including cells on another sheet in the same spreadsheet. Keep that range organized so the dropdown does not include unrelated values.

Can I let people enter values that are not listed?
Yes, if the rule is configured to show a warning rather than reject invalid data. That setting is useful when the list is a suggestion, but it may reduce consistency in data that will be summarized later.

How do I change a dropdown option?
For custom choices, select a cell with the rule and edit the items through Data > Data validation. For a range-based dropdown, edit the source cells or correct the source range in the rule.

Why does deleting the dropdown leave text in the cell?
The rule controls validation, not the cell’s stored contents. Remove the rule through Data > Data validation; if you also want the existing choice gone, clear the cell separately.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.