Adding a Dropdown in Google Sheets

To add a dropdown in Google Sheets in a web browser, select the cell or cells, choose Insert > Dropdown, enter the choices in the panel, and click Done. You can also choose Data > Data validation > Add rule to create a dropdown from typed choices or values in a cell range.

What a Google Sheets dropdown does

A dropdown gives people a set of values to choose from in a cell, rather than asking them to type an answer from scratch. It is useful for repeatable entries such as task status, department, priority, payment method, or a yes-or-no response. The cell still stores the selected value as ordinary spreadsheet content, so you can sort, filter, count, and use it in formulas like other cell values.

Dropdowns are created through data validation rules. A rule can offer a list you type into the settings or use values held in a range elsewhere in the spreadsheet. You can also decide what happens if someone enters a value that is not on the list. This makes a dropdown more than a visual menu: it can help standardize information across a shared sheet.

Add a dropdown with typed choices

For a short list that is unlikely to change often, type the options directly into the rule. In the Google Sheets web app, follow these steps:

Select one cell or a group of cells where the dropdown should appear. To apply the same rule to a whole column, select the intended range, such as B2:B100, rather than the column heading.
Choose Insert > Dropdown. A data validation rule panel opens on the right side of the sheet.
Under the criteria, choose the dropdown option if it is not already selected. Add or edit the option labels, and use the controls in the panel to add more choices or remove ones you do not need.
Optionally assign colors to choices or adjust the display style. Check the selected range and rule settings, then click Done.

After the rule is saved, the selected cell displays a dropdown indicator when you select it. Click the cell and choose an option. If the rule covers several cells, each one gets its own selection; choosing a value in one cell does not automatically fill the others.

Use values from a range instead

A range-based dropdown is often easier to maintain when the list is long or may change. Put the approved options in a dedicated area, such as a sheet named Options with values in A2:A6, then select the cells that need the dropdown. Choose Insert > Dropdown, or open Data > Data validation > Add rule, and set the criteria to Dropdown (from a range). Enter or select the source range, such as Options!A2:A6, and click Done.

When you change the values in the source range, the dropdown uses the updated list. This avoids opening and editing the validation rule every time an option is renamed or added. Keep the source list organized: remove accidental blanks, avoid duplicate labels if they would confuse users, and put the choices in an order that makes sense. If the sheet name contains spaces, Google Sheets may show it with single quotation marks in a range reference, for example ‘Task Options’!A2:A6.

Consider placing lookup lists on a separate tab so the working sheet stays uncluttered. A separate tab does not make the list private or secure: anyone who can access the spreadsheet may be able to view it, depending on their permissions. Protecting a range can help prevent accidental edits, but it is not a substitute for managing file access.

Choose how the rule handles entries

When setting up a dropdown, decide whether people must use an approved choice or may enter something else. In the rule panel, the invalid-data setting can be configured to reject input or show a warning. Rejecting input enforces the list for ordinary edits; showing a warning allows a non-listed value but flags that it does not match the rule. Choose based on the purpose of the column: a fixed status field usually benefits from strict choices, while a feedback field may need to accept unplanned responses.

Dropdown display style affects how the choice appears, not the underlying meaning of the data. Depending on the available style controls, you can use colored chips, an arrow, or plain text. Chips are visually prominent and can make status columns easier to scan, while plain text is less decorative. Colors should reinforce readable labels rather than replace them; a color alone may be unclear to people viewing the sheet with different display settings or color perception.

These settings do not prevent every possible change to a spreadsheet. For example, someone with editing access may alter the rule itself, and pasted or imported data can require review. Validation is a practical consistency aid, not a security boundary or a guarantee that every cell will always contain an approved value.

Edit, remove, or apply a dropdown to more cells

To change an existing dropdown, select a cell governed by the rule and choose Data > Data validation. Review the rule in the panel, make the change, and save it. You can also select a cell and use Insert > Dropdown to open the dropdown controls. If multiple rules apply to a selection, check the displayed range carefully before editing so you do not change a different set of cells than intended.

To remove a rule, select the affected cell or range, open Data > Data validation, and use the option to remove the rule in the panel. Removing validation does not necessarily erase values already stored in those cells; it removes the restriction or dropdown behavior. If you only want to stop showing the menu in one part of a range, adjust the rule’s applied range rather than deleting the rule from the entire area.

For a new area, you can select the additional cells before creating the rule. If a rule already exists, inspect its applied range in the data validation panel and edit the range as needed. This is useful when a table grows, but avoid applying a dropdown to an entire sheet without a reason: broad rules can make future editing confusing and may affect cells intended for other information.

Examples of useful dropdown lists

A task tracker might have a Status column with choices such as Not started, In progress, Blocked, and Complete. A request form could offer Department values maintained on an Options tab. A simple inventory sheet could use a Condition list such as New, Good, and Needs review. In each case, consistent labels make filtering and summaries more reliable than a mixture of entries like Done, finished, and complete.

For a shared sheet, make the options specific enough to guide people but not so numerous that the menu becomes hard to use. Before publishing the sheet, test the rule in a few cells: select an option, try typing an unlisted value if appropriate, and verify that the rule covers the cells people will actually fill in. If users need to explain an exception, provide a neighboring notes column rather than turning every dropdown choice into a long sentence.

Common dropdown problems and fixes

The dropdown arrow is not obvious: Select the cell and check whether a validation rule is present. The indicator may be more noticeable when the cell is selected, depending on its display style.
A choice is missing: For a typed list, edit the rule and add the option. For a range-based list, inspect the source range and expand it if the new value sits outside the referenced cells.
A value is rejected: Check for spelling, extra spaces, or a mismatch with the listed choice, then review whether the rule rejects invalid data or only warns about it.
The wrong cells have dropdowns: Open Data > Data validation and inspect the applied range. Correct the range rather than recreating the rule without checking what it currently affects.
The list has duplicates or blanks: Clean up the source cells, then check the dropdown again. A range-based list reflects its source data, so stray entries there can make the menu confusing.

Also distinguish between the value displayed in the cell and the rule that controls it. Clearing a cell’s contents does not necessarily remove its dropdown, and removing a dropdown rule does not automatically clear existing contents. If a pasted value does not behave as expected, inspect both the cell’s current content and its validation rule.

Google Sheets dropdowns compared with Excel

Google Sheets and Microsoft Excel both support dropdown lists, but their menus and rule dialogs are different. In Sheets, use Insert > Dropdown or Data > Data validation > Add rule. In Excel for Microsoft 365 on Windows, dropdown lists are set up through Data > Data Validation, with List selected as the validation criterion. Instructions for one program should not be assumed to match the other, even though the purpose is similar.

If you work in both programs, check the list and validation behavior after moving or importing a workbook. Features and formatting may not transfer exactly, and a source range that works in one application may need adjustment in the other. For a sheet that stays in Google Sheets, the native dropdown rule is generally the clearest way to provide controlled choices.

Frequently Asked Questions

Can I add a dropdown to an entire column?

Yes. Select the cells in the column that should use the rule, such as B2:B500, and create the dropdown. Selecting a bounded range instead of the whole column helps avoid applying validation to headings or unrelated cells.

Can a dropdown list come from another sheet?

Yes. Choose Dropdown (from a range) and enter or select the cells on the other sheet, such as Options!A2:A6. The source values can then be maintained separately from the cells where people make selections.

Can I allow an entry that is not on the list?

Yes, if you set the invalid-data behavior to show a warning rather than reject input. The warning makes the mismatch visible while allowing the value. If entries must stay standardized, use the reject-input setting instead.

How do I remove a dropdown but keep its current value?

Select the cell or range, open Data > Data validation, and remove the rule. Removing validation changes the cell’s dropdown behavior; it does not by itself delete the value already in the cell.

Why do changes to my source list not appear?

Check that the dropdown uses the correct source range and that the changed value is inside it. If you added a choice below the original range, update the range reference to include that cell, then save the rule.

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.