Google Sheets Text Dropdown: How to Add One

To add a text dropdown in Google Sheets, select the cell or range, choose Insert > Dropdown, enter each choice as an option, and click Done. You can also use Data > Data validation to create the rule or build the choices from a range of cells. This guide covers both approaches in Google Sheets in a web browser, plus how to edit the list and fix common problems.

What You’ll Need

A Google account and a spreadsheet you can edit, open in a web browser.
The cell or cells where you want people to choose an answer.
Your text choices, such as Open, In progress, and Complete. If you plan to use a source range, put the choices in cells first.

You do not need a formula, add-on, or special spreadsheet format. A dropdown is a data validation rule: it gives a cell a set of choices and can help keep entries consistent. Anyone who has permission to edit the sheet can usually use the dropdown; changing its rule requires permission to edit the spreadsheet.

Step-by-Step

Select the destination cell or range. Click one cell for a single dropdown. To apply one list to several cells, select the whole range first, such as B2:B50. You can also select a full column, but applying a rule only to the rows you expect to use can make the sheet easier to manage. The selected range appears in the rule settings, where you can check that it is correct.
Open the dropdown rule. Choose Insert > Dropdown from the menu. Google Sheets opens a rule-editing panel on the right. Alternatively, choose Data > Data validation, then click Add rule. The two routes lead to the same kind of validation setup; the exact panel wording may shift as Google updates Sheets.
Choose how to supply the text choices. In the criteria section, select Dropdown to type choices directly into the rule. Select Dropdown (from a range) if you have already entered the list in spreadsheet cells and want the menu to use those values. Check the selected criterion before entering options; choosing a range-based list when you meant to type choices can make the setup seem confusing.
Enter options for a typed list. Add each choice in its own option field, for example: Not started, In progress, and Done. Use Add another item to create more choices. Keep each option distinct and concise. The dropdown displays these options as selectable values; they are not separate rules or separate destination cells.
Set up a source range if you want a maintainable list. First, enter one choice per cell in an unused area of the sheet, for example H2:H4. In the rule panel, choose Dropdown (from a range) and enter or select H2:H4 as the source. Use the range picker if available, then confirm the range. The source cells should contain the exact text you want users to select. If the list is on another tab, include that tab in the range reference using the sheet name and cell range.
Review the appearance and invalid-entry behavior. You may be able to assign colors to options and choose a display style such as chip, arrow, or plain text. These affect how the value appears in the sheet, not which choices are available. Expand Advanced options if you want to control invalid entries. Reject input prevents a user from entering a value outside the list; Show a warning allows it but flags the value. Choose based on whether the list must be followed strictly.
Save and test the dropdown. Click Done to save the rule. Select a destination cell and open its dropdown using the arrow or chip. Choose an option, then check that the displayed value is the one you intended. If you applied the rule to a range, test a second cell in that range too. This catches mistakes such as selecting only the first cell before creating the rule.
Edit the choices later when needed. Select a cell with the rule and open Data > Data validation to review or change it. For a typed list, edit the option fields. For a range-based list, update the source cells; the dropdown can then reflect the changed choices. Review the applied range as well, especially if new rows have been added since you first created the rule.

For a simple one-off list, typed options are usually fastest. A source range is more convenient when the choices may change, when the same list is used in multiple places, or when someone else needs to maintain the options. In either case, you can use ordinary text, such as department names, priorities, or response statuses.

Common Mistakes

Applying the rule to the wrong cells. A dropdown only appears in cells covered by its applied range. Check the range in the rule panel if it is missing from some rows, or if it appears in cells where it should not.
Typing several choices into one option. If you enter Open, In progress, Complete as one option, Sheets may treat the whole phrase as a single choice. Add each value in its own option field, or place each value in a separate source cell.
Using a source range that includes unrelated cells. Extra notes, blank space, or headings in the referenced range may produce unwanted choices. Keep the source list tidy and point the rule only at the intended cells.
Expecting the dropdown to fill other cells automatically. Choosing a value changes the selected cell only. It does not populate neighboring cells or create a form. Apply the validation rule to all intended destination cells before testing.
Assuming a dropdown blocks every other edit. The invalid-data setting matters. Show a warning permits a non-list value with a warning, while Reject input is the stricter choice. Also, editors who can change the sheet may be able to modify or remove the rule.
Confusing Google Sheets instructions with Excel instructions. In Sheets, use Insert > Dropdown or Data > Data validation. Excel has its own Data Validation controls and labels, so the menus and steps are not interchangeable.

Tips

Use short, unambiguous labels. Choices like High, Medium, and Low are easier to scan than long descriptions. If users need definitions, add a note or an instruction near the column heading rather than making every choice lengthy.
Keep a shared list in one place. A source range makes updates easier when multiple dropdown rules use the same choices. Put the list in a clearly labeled area or a dedicated tab, and avoid casually sorting or deleting its cells.
Apply the rule to the expected working area. If users will add rows, include enough rows in the range or extend the rule when the sheet grows. Recheck new rows, since a row inserted or pasted into the sheet may not always have the validation you expected.
Choose the display style for the task. Colored chips can make statuses easy to recognize at a glance; an arrow or plain text may suit a compact, low-decoration sheet. Color is a visual aid, so keep the words meaningful and do not rely on color alone.
Consider who will use the sheet. If collaborators must select only approved values, use Reject input and explain the choices near the column. If exceptions are legitimate, Show a warning may be less restrictive, but someone should review flagged entries.
Keep spreadsheet permissions in mind. A dropdown helps standardize entries; it is not a security control. Protect sensitive data and manage sharing permissions separately if users should not edit particular cells or tabs.

Troubleshooting

The dropdown arrow or chip is not visible. Click the cell and check Data > Data validation to see whether a rule exists and whether its applied range includes that cell. If there is no rule, select the right cells and create one. If the cell is part of a merged area or has unusual formatting, test the rule in a regular, unmerged cell to narrow down the cause.

A choice is missing from the menu. For a typed list, reopen the rule and confirm that the text is present as its own option. For a range-based list, inspect the source range and verify that it includes the cell containing the missing choice. If you added a new choice below the original source range, extend the range in the rule to include it.

Sheets rejects a value you expected to accept. Check spelling, spacing, and punctuation against the listed option. A manually typed value can differ by a trailing space or a slightly different label. If the value should be allowed even when it is not in the list, change the invalid-data behavior to Show a warning; otherwise, correct the source choice or select the intended option.

The dropdown appears in only some rows. Open the rule and review the applied range. Edit it to include all required cells, then save the change. If different rows have different validation rules, review each rule rather than assuming one edit covers the whole column.

The choices do not update after editing the source list. Confirm that the rule still points to the cells you changed and that the new text is inside the referenced range. A typed list does not read from source cells, so changes to unrelated cells will not update it; edit the options in the rule instead.

You cannot change the rule. Confirm that you have edit access to the spreadsheet and that the relevant cells or sheet are not protected from your account. If you only need to choose a value, you do not need to edit the validation rule; ask the spreadsheet owner to adjust it if the available choices are wrong.

Frequently Asked Questions

Can I add a dropdown with my own text choices?
Yes. Select the target cells, choose Insert > Dropdown, and enter each label as a separate option. Click Done to apply the list.

Can I make a dropdown from cells in another tab?
Yes. Choose Dropdown (from a range) and specify the source cells on the other tab. Check the range reference in the rule panel and make sure it points to the intended sheet and cells.

Can I use the same text dropdown in many cells?
Yes. Select the destination range before creating the rule, or edit the rule’s applied range afterward. Test more than one cell to confirm the rule covers the full range.

Can I let people type a value that is not on the list?
Yes. In the rule’s advanced options, choose Show a warning instead of Reject input. This allows other entries but marks them as outside the list; it does not add them as dropdown choices.

Can I change or remove a dropdown after creating it?
Yes. Select a cell with the rule and open Data > Data validation to edit it. To remove the dropdown, use the option to remove the validation rule, taking care to select the intended cell or range.

Is adding a dropdown the same in Excel?
No. These steps are for Google Sheets in a web browser. Excel has a separate Data Validation feature and a different interface, so use instructions written specifically for your Excel version.

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.