Google Sheets Cell Dropdown List: Setup and Tips

To create a cell dropdown list in Google Sheets, select the cell or range, choose Insert > Dropdown, add the choices, and click Done. You can also use Data > Data validation > Add rule to create a list from typed options or values stored in another range.

What a Google Sheets cell dropdown does

A dropdown gives people a set of choices to select inside a spreadsheet cell instead of relying on everyone to type the same value consistently. It is useful for fields such as task status, department, priority, payment method, or whether an item has been reviewed. A small arrow or colored chip indicates that a cell has choices; selecting it reveals the available options.

Dropdowns are built with data validation rules. A rule can display a list and, depending on its settings, prevent entries outside that list or show a warning when someone enters a different value. This can make a sheet easier to fill in and reduce variations such as Open, open, and In progress appearing in the same status column.

A dropdown is not a filter, a formula, or a security control. It helps guide data entry, but it does not by itself determine who can edit a cell or guarantee that all data in a workbook is valid. Use sharing permissions and other checks for those needs.

Create a dropdown with typed choices

In Google Sheets in a web browser, select the cell or cells where the dropdown should appear. Choose Insert > Dropdown. Sheets opens a rule editor where you can enter the choices and adjust how the dropdown appears. When the choices are ready, click Done.

Select one cell, or drag across a range such as C2:C100 if the same choices should be available in many rows.
Choose Insert > Dropdown. Alternatively, open Data > Data validation and choose Add rule.
In the rule editor, use the dropdown criterion and enter each option as a separate item. For example, a task tracker might use Not started, In progress, and Complete.
Review the display and invalid-data settings, then click Done.

After setup, select a cell with the rule and choose an option from its menu. Selecting a choice writes that value into the cell. You can still edit the rule later, for example to add another status or change its display color. Menu labels and the rule editor can change as Google updates Sheets, but Insert > Dropdown and Data > Data validation are the relevant entry points in the browser version.

Use values from a range

A range-based dropdown takes its choices from cells in the spreadsheet. This is helpful when the list is long, when several columns need to share the same choices, or when you want to maintain options in one place. For example, you could put departments in Lists!A2:A6 and create a dropdown in the Department column using that range. The source cells can be on a separate tab named Lists.

To set one up, select the cells that need the dropdown and open Insert > Dropdown or Data > Data validation > Add rule. In the criteria, choose Dropdown (from a range), then enter or select the range containing the options. Confirm the rule with Done. Keep the source list free of unintended blank cells or duplicate entries if you do not want them to appear as choices.

Range-based lists are easier to maintain than manually retyping choices in multiple rules. If the source value changes, the dropdown reflects that list change. However, do not assume that every newly added item will be included if it is typed beyond the range specified in the rule. If the source is Lists!A2:A6 and a new choice goes in A7, edit the rule to include A7 or choose a source range with room for future additions. A deliberately sized range can save maintenance, but including a large number of blank rows may make the dropdown less tidy.

Choose how the dropdown looks and handles entries

Google Sheets lets you adjust the display style of a dropdown. Depending on the options available in the rule editor, choices can appear as colored chips, an arrow-style control, or plain text. Chips can make statuses stand out visually, while plain text has a quieter appearance in a dense table. Colors are presentation cues; they do not replace the text value, and color alone should not be the only way a reader identifies a status.

The invalid-data setting determines what happens when someone tries to enter a value that is not in the list. Reject input is appropriate when the column should contain only approved choices. Show a warning is more flexible: it alerts the editor but allows an unusual value to remain. For instance, a survey response sheet might reject unlisted answers, while a project log could allow a temporary status that has not yet been added to the official list.

Choose the behavior based on how the sheet will be used. A strict rule can improve consistency, but it can also obstruct legitimate exceptions. A warning supports flexibility, but users may overlook it. If other people will fill in the sheet, make the purpose of the field and the available choices clear in the column heading or nearby instructions.

Plan the list for a real spreadsheet

Before adding a rule, decide whether the options should be manually entered in the rule or maintained in cells. A short, stable list such as Yes and No is usually easy to type directly. A shared list of product names or departments is usually easier to manage in a source range, because an authorized editor can update the source rather than locating every rule that repeats the choices.

Think through the exact wording and order of the items. Put the most common or natural next choice near the top, and use labels that people can distinguish quickly. If a status list includes In progress and Waiting for review, explain any difference that may not be obvious to a new editor. Avoid using several near-synonyms if reports or filters will later treat them as different values.

For a task tracker: Not started, In progress, Blocked, Complete.
For an approval field: Pending, Approved, Needs changes, Declined.
For a simple attendance field: Present, Absent, Excused.

For lists with many options, keep the source values in a clearly labeled section or a dedicated tab. Protecting that area from accidental edits can help preserve the list, but protection is separate from dropdown validation and must be configured independently.

Apply, edit, copy, or remove a rule

A rule can apply to a single cell or a range. If you selected C2:C100 before creating it, those cells can share the same choices. You can also review and manage rules through Data > Data validation. This is useful in a workbook with many dropdowns, where selecting a cell and inspecting its rule can help identify the source list and settings.

To change a list, select a cell covered by the rule and open the validation settings. Edit the options, source range, or invalid-data behavior, then save the change. When the same rule covers multiple cells, an edit to that rule applies to its covered range. To remove a dropdown, select the relevant cell or range, open Data > Data validation, and remove the rule. Removing validation does not necessarily erase the text already stored in the cells; it removes the restriction or menu rule.

Copying a cell can also copy its validation rule, depending on what you paste. If you only want to reuse the dropdown, check that the destination cells have the intended rule and that any range-based source still points to the right list. Before making broad changes, inspect a few cells from different parts of the target range.

Common problems and practical fixes

If a dropdown does not appear, first select the cell and check Data > Data validation to see whether a rule is attached. The cell may be outside the range you originally selected, or the rule may have been removed when someone pasted other content. Confirm that the rule applies to the intended cells and click Done after editing.

If an expected choice is missing from a range-based list, check the source range in the rule. A new option may have been added just beyond its endpoint, or the source cell may be blank or contain a spelling different from the intended label. If the list contains duplicates, inspect the source cells and remove repeated values if they are not meaningful choices.

If a cell contains a value that is not in the list, check whether the rule uses Show a warning rather than Reject input. Also consider whether the cell was filled by pasting data or by an import; pasting can bring in content or rules that differ from what you expect. Validation is a data-entry aid, so review important columns after bulk edits and correct inconsistent values before relying on them in summaries.

Finally, distinguish a dropdown from conditional formatting. A dropdown supplies selectable values; conditional formatting changes how cells look based on their contents. You can use both together—for example, a status dropdown plus formatting that highlights Blocked—but each feature has its own settings.

Google Sheets dropdowns compared with Excel

Both Google Sheets and Microsoft Excel provide dropdowns through data validation, and both can use typed choices or a range of cells. The concepts are similar, but the menus and rule editors are not identical. The steps in this guide are for Google Sheets in a web browser; Excel users should look for Data Validation on Excel’s Data tab rather than follow Google Sheets menu paths.

When a file is opened or converted between spreadsheet programs, check the dropdowns rather than assuming every rule and visual detail transferred exactly. Inspect the allowed values, the cells covered, and whether invalid entries are blocked or merely flagged. If a workbook is shared across both programs, test the workflow in each one that contributors will use.

Frequently Asked Questions

Can I make a dropdown list in Google Sheets on my phone?
Google Sheets mobile apps can display and use many existing dropdowns, but the editing experience and available rule controls can differ from the web browser. For creating or carefully managing rules, use Sheets in a desktop browser and verify the result on the devices contributors use.

How do I add another option to a dropdown?
For a manually entered list, edit the dropdown rule and add the choice. For a range-based list, add the value within the source range or update the rule to include the new cell, then save the change.

Can one dropdown list be used in multiple cells?
Yes. Select the full target range before creating the rule, or edit the rule’s applied range so it includes the cells that need the same choices. Check the range afterward to avoid applying it to headings or unrelated cells.

Can a Google Sheets dropdown allow more than one selection?
Dropdowns are generally used to place one selected value in a cell. Sheets may offer a multiple-selection setting in the dropdown rule editor for supported configurations; availability and behavior can vary, so check the current editor and test it in the browser before building a workflow around it.

Why can someone type a value that is not in the list?
The rule may be set to show a warning instead of rejecting input, or the cell may not have the rule you expected. Check Data > Data validation, confirm the applied range, and select Reject input if entries outside the list should be blocked during normal editing.

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.