How to Add Dropdown Values in Google Sheets Step by Step

To add dropdown values in Google Sheets, select the cell or cells, choose Insert > Dropdown, then add each choice in the panel and click Done. You can also create a dropdown from Data > Data validation, including one whose choices come from a range of cells. Dropdowns make entries consistent, easier to select, and simpler to sort or summarize later.

What You’ll Need

A Google account with access to a spreadsheet you can edit, opened in a web browser.
The cells where the dropdown should appear.
The choices you want people to select, or a range of cells containing those choices if you want a list that is easy to maintain.

You do not need an add-on or a special spreadsheet template. If you only have permission to view or comment on a file, ask its owner for editing access before trying to add or change a rule.

Step-by-Step

Select the destination cells. Click the cell where you want the menu, or drag across a range such as B2:B30 to apply the same dropdown to several rows. You can select a whole column if every cell should use the rule, but avoid applying it to a large unused area unless that is intentional. The dropdown will be available in each selected cell.
Open the dropdown controls. For the quickest setup, choose Insert > Dropdown from the menu bar. Google Sheets opens a panel where you can configure the rule. If you prefer the validation settings, choose Data > Data validation and select Add rule if the panel offers that option. Both routes let you create a dropdown; the wording and arrangement of controls may change slightly as Google updates its interface.
Check the range to apply the rule to. In the panel, look for Apply to range. Confirm that it shows the cell or cells you selected. If you opened the panel first or want to change the target, enter a range such as C2:C50, or use the range selector to choose the cells directly in the sheet. Check the starting row carefully so you do not accidentally put headings or unrelated data in the dropdown range.
Choose how to supply the choices. For a short list that will not change often, select the Dropdown criterion. The panel displays rows for individual options. To use values already written in cells, choose Dropdown (from a range) and specify the source range. For example, you might keep statuses in a separate list and use that range as the source. A range-based list is useful when you expect to revise the choices, because you can maintain the source cells instead of editing every rule separately.
Enter or select the dropdown values. For a manually entered list, click the first option field and type a value, such as Not started. Use Add another item to create another row, then enter the next choice, such as In progress and Complete. Each option is a separate selectable value. For a range-based list, use the range field or its selector to choose the cells that contain the choices, then confirm the range. Keep the source list free of unintended blank rows if you want the menu to contain only meaningful choices.
Set how Sheets handles other entries. Open the advanced options if they are shown. Under the invalid-data setting, choose Reject input when users should only choose an offered value, or Show a warning when other entries may be allowed but should be flagged. A warning does not necessarily prevent someone from typing a different value. Choose based on how strict the sheet needs to be; for a controlled status field, rejecting unlisted entries is often the clearer choice.
Choose the display style and colors if useful. Depending on the panel, you can show choices as a chip, an arrow, or plain text, and may be able to assign colors to options. Colors can help distinguish categories, but the words should still make sense without color. Use short, readable labels, and avoid making a color the only way users can understand what an option means.
Save the rule and check it. Click Done to apply the setting. Click one of the target cells and open its dropdown using the arrow or chip control. Select a choice and confirm it appears in the cell as expected. If you selected a range, check a cell near the bottom too. This quick check can catch a range that was applied to only one row or a source list that points to the wrong cells.

To add another value later: select a cell covered by the rule, open Data > Data validation, and edit the existing rule in the panel. For a manually entered list, use Add another item, enter the new choice, and click Done. For a range-based dropdown, add the value to the source list and check that the rule’s range includes its cell. Updating the source list alone will not help if the new value sits outside the referenced range.

These instructions are for Google Sheets in a web browser. Excel has its own data-validation controls and menu paths, so do not expect Google Sheets steps such as Insert > Dropdown to match Excel.

Common Mistakes

Typing multiple choices into one option row. If you type something like Not started, In progress, Complete into a single item field, Sheets may treat the whole text as one choice. Add each option on its own row using Add another item.
Applying the rule to the wrong cells. A common cause is selecting a heading or starting one row too high or too low. Verify Apply to range before saving, especially when the sheet has a header row.
Choosing warning when you meant to enforce the list. Show a warning alerts users about values outside the list but may allow them to keep the entry. Choose Reject input if unlisted entries should not be accepted.
Forgetting to expand a source range. A range-based dropdown only uses the cells covered by its source reference. If you add a choice just below that range, it may not appear in the menu until you edit the rule to include it.
Leaving confusing or duplicate choices. Similar labels, extra spaces, and repeated entries make menus harder to use. Review the list before saving, and use consistent wording such as either all title case or all sentence case.

Tips

Use a source list for choices that change. Put the values in a clearly labeled area, such as a separate tab named Lists, and connect the dropdown to those cells. This makes the options easier to review and update. Keep the source list tidy and tell collaborators not to overwrite it accidentally.
Apply one rule to future rows. If you expect more records, select a generous range below the header, such as B2:B200, rather than setting up each new row individually. Do not select the entire sheet without a reason, since that can make rules harder to manage.
Make the choice labels self-explanatory. Use terms people recognize in the context of the sheet. For a task tracker, labels like Not started, In progress, and Complete are clearer than abbreviations that require a separate explanation.
Keep the header outside the validated range. Put labels in row 1 and apply the dropdown from row 2 onward. That preserves a clean heading and reduces the chance that someone will choose a dropdown value instead of reading the column name.
Consider who will edit the file. If several people enter data, explain what the choices mean and whether they may type a value outside the list. A dropdown guides entry, but it does not replace clear instructions or appropriate sharing permissions.

Troubleshooting

The dropdown arrow or chip is not visible. Click the cell to see whether the control appears, and confirm that the cell is included in the rule’s Apply to range. Open Data > Data validation to inspect the rule. If no rule is listed for that cell, select the intended range and add one.
A new choice does not appear. If you used a manually entered dropdown, edit the rule and add the value as a separate item. If you used a range, check that the new entry is inside the referenced cells, that the spelling is correct, and that the rule points to the intended source range.
Someone can enter a value that is not on the list. Edit the rule and check the invalid-data behavior. Change Show a warning to Reject input if you want Sheets to block entries outside the dropdown. Existing values may need to be reviewed separately after changing the rule.
The menu shows the wrong options. Reopen the rule and inspect the source range or the manually entered items. For a range, check the sheet name, row numbers, and the actual contents of the selected cells. Correct the source or reference, click Done, and reopen the menu to verify the change.
You cannot edit the dropdown. Confirm that you have editor access and are not viewing a protected range that you cannot change. If another person owns or protects the sheet, ask them to update the rule or grant the required access.
Only some cells have the dropdown. Check whether the rule’s apply-to range covers every intended row. Edit the range in the rule or create a rule for the missing cells. Also check for overlapping or separate rules that may have been created for different parts of the column.

Frequently Asked Questions

Can I add a dropdown to multiple cells at once?
Yes. Select the destination range before creating the rule, such as D2:D40, and the same dropdown will be available in each selected cell. Confirm the range in Apply to range before clicking Done.

Can dropdown choices come from another sheet?
Yes. Choose Dropdown (from a range), then use the range selector to choose the cells containing the list, including cells on another tab if available in the selector. Check the sheet name and range before saving so the menu uses the intended source.

How do I change or remove a dropdown?
Select a cell covered by the rule and open Data > Data validation. Edit the existing rule to change its choices or settings. To remove it, select the rule and use the option to remove the rule in the panel; check the target range so you do not remove a different validation rule by mistake.

Can I let people type their own value as well as select a choice?
Yes, if the rule is set to Show a warning, Sheets can flag an unlisted entry while allowing it. If it is set to Reject input, an entry outside the list is blocked. Decide whether consistency or flexibility matters more for that column.

Will adding a dropdown erase values already in the cells?
Creating a validation rule does not normally replace the existing cell contents. However, existing entries may not match the new choices, particularly if you choose to reject invalid input. Review old data and standardize it if you need every row to follow the same list.

Can I use a dropdown in the Google Sheets mobile app?
Dropdowns can be used in the mobile app, but the controls for creating or editing rules can differ from the web interface. For the clearest setup, create and manage the rule in Google Sheets in a browser, then check that the dropdown works on the devices your collaborators use.

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.