How to Add a Dropdown Menu in Google Sheets Easily

To add a dropdown menu in Google Sheets, select the cell or cells, choose Insert > Dropdown (or Data > Data validation), enter choices or select a range containing them, and click Done. The dropdown lets people choose from approved options instead of typing each answer, which can make a shared sheet easier to fill in and keep consistent. These instructions are for Google Sheets in a web browser.

What You’ll Need

A Google account with access to the spreadsheet. If it belongs to someone else, you may need editor permission to add or change validation rules.
The spreadsheet and the cells where you want the dropdown.
Your list of choices, either ready to type into the rule or entered in cells so you can use them as a source range.

You do not need an add-on or a formula for a basic dropdown. If other people will use the sheet, decide in advance whether they should be limited to your listed choices or allowed to enter something different. That choice affects how the rule handles invalid entries.

Step-by-Step

Choose where the dropdown should appear. Open the spreadsheet and click the cell that should contain a dropdown. To apply the same menu to several cells, select the full range first—for example, B2:B50. You can also select a column or multiple non-adjacent cells with the usual browser selection methods, but a simple continuous range is easiest to check later. Avoid selecting a heading cell unless you want a dropdown in the heading too.
Open the dropdown settings. In the top menu, choose Insert > Dropdown. The data-validation rule editor opens, usually as a panel on the right. You can also open it through Data > Data validation. The wording or layout may shift slightly as Google updates Sheets, but both paths lead to the validation settings. If a rule already exists for the selected cells, the editor may show that rule so you can change it rather than create a separate one.
Choose how to supply the choices. In the rule editor, find Criteria. Select Dropdown to type choices directly into the rule, or select Dropdown (from a range) to use values already entered in spreadsheet cells. A typed list works well for a short, stable set such as Not started, In progress, and Done. A source range is more convenient if the list is long, likely to change, or should be maintained in one visible place.
Enter choices if you selected Dropdown. Add each choice as its own item in the editor. Use the option to add another item for each additional choice, then replace the sample text with the wording you want displayed. Put the clearest choice first; that is the first option people will see when they open the menu. Keep labels distinct, such as “In progress” and “Complete,” rather than creating options that are difficult to tell apart. If the editor offers colors for the choices, you can assign them now, but colors are optional.
Select a source range if you chose Dropdown (from a range). Use the range field or its range-picker control to identify the cells containing your list, then confirm the selection. For example, you might keep status labels in a separate “Lists” tab and use those cells as the source. Include the choice cells, not the heading above them. A source range is useful when you want to update the menu by editing the list in the sheet, but make sure the range points to the correct tab and cells. If you later add choices beyond the selected range, edit the rule so that it includes those new cells.
Check the cells the rule applies to. Look at the Apply to range field and confirm it matches your selection. This is important if you opened the rule editor with the wrong cell selected or are editing an existing rule. A range such as B2:B50 applies the dropdown to those cells only. If the rule should cover future rows, you can use a larger range, such as B2:B500, or apply it to an appropriate portion of the column while excluding the header. Choosing a practical range avoids putting a menu in titles or unrelated cells.
Set how invalid entries are handled. In the rule’s advanced options, review the setting for invalid data. Choose Reject input if entries must match one of your choices. Choose Show a warning if people should be able to type a different value but should see that it is outside the list. Rejecting input helps protect standardized data, while a warning is more flexible for notes or situations where exceptions may be legitimate. Do not assume the rule will clean up values already in the cells; check existing entries separately if you are adding validation to a sheet that is already in use.
Choose how the menu looks and save it. If available in the editor, select a display style such as Chip, Arrow, or Plain text. Chips make selected values stand out; an arrow gives a more compact dropdown indicator; plain text is less visually prominent. Click Done to save. Click one of the validated cells and open its dropdown to confirm the choices appear and select one. If you applied the rule to a range, test another cell in that range too.

Once saved, people can use the menu in a cell to choose an option. The choice is stored as the cell’s value, so it can also be sorted, filtered, counted, or used in other spreadsheet work. Google Sheets updates the selected value when someone makes a different choice; it does not create a separate record of each past selection.

Common Mistakes

Including the list heading in the source range. If your source list begins with a label such as “Status,” selecting the heading along with the options can make that label appear as a choice. Select only the cells that contain actual options.
Applying the rule to the wrong cells. A dropdown on the header row or an unrelated column is usually a range-selection error. Check Apply to range before saving, especially when editing a rule that already exists.
Typing multiple choices into one item. Enter each choice as a separate item in the Dropdown editor. If you type “Low, Medium, High” as one item, Sheets may treat the whole phrase as a single choice rather than three options.
Using Reject input when exceptions are needed. This setting prevents values outside the list from being accepted through normal entry. If users need to record an occasional exception, use a warning or add an explicit “Other” option and provide a place to explain it.
Assuming a new option will appear automatically. With a range-based dropdown, adding a value outside the range used by the rule will not add that value to the menu. Expand the source range when you extend the list.
Expecting validation to fix old or pasted data. A rule guides future entry, but it does not automatically replace values already present. Pasted or imported content may also leave values that need review. Check the cells and their validation warnings rather than assuming every entry is valid.

Tips

Keep reusable choices on a separate tab. A tab named “Lists” or “Setup” can hold options without cluttering the working sheet. Use clear headings and keep each list in its own column so it is easy to identify the correct source range.
Make choices brief and unambiguous. Labels should be easy to scan in a small cell. For example, “Needs review” is clearer than an abbreviation that only the sheet’s creator understands. If two choices mean nearly the same thing, clarify the distinction before sharing the spreadsheet.
Plan for growth. If your source list will grow, include enough cells in the referenced range or remember to update it when you add options. For a typed list, reopen the validation rule to add or change choices. Either way, the menu and the cells that feed it should stay in sync.
Use one rule across similar rows. Selecting the intended range before creating the rule can save time and reduce inconsistent settings. For example, apply the same status menu to all task rows rather than rebuilding it one cell at a time.
Use colors as cues, not as the only meaning. A colored chip can help people scan statuses quickly, but the text should still make sense without color. This is useful for readers with color-vision differences and for printed copies.
Protect the source list if needed. If collaborators should choose from the list but not change the options, consider protecting the cells or tab that stores the source values. Share permissions and protected ranges are separate from dropdown validation, so set them deliberately.

Google Sheets and Excel both support dropdown-style data validation, but the controls are not in the same place. These instructions use Google Sheets’ Insert > Dropdown and Data > Data validation menus; do not follow Excel’s ribbon instructions for this task. Excel’s interface and some available validation settings differ.

Troubleshooting

The dropdown does not appear. Click the cell and check whether the rule was saved and whether that cell is included in Apply to range. Reopen Data > Data validation to inspect the rule. If you selected a large range, verify that you are testing a cell inside it rather than the header or a neighboring column.
The list is empty or shows the wrong choices. Open the rule and inspect the source range. Confirm that it points to the correct sheet and cells, that those cells contain the intended values, and that the range does not start on an unintended heading. If you typed options directly, check that each item was added separately.
You cannot enter a value that is not listed. The rule is probably set to Reject input. If exceptions are allowed, change the invalid-data behavior to Show a warning, or add an option such as “Other.” If the list should be strict, leave rejection in place and select a valid choice instead.
A new source-list choice is missing. Check whether the new value is inside the range used by the rule. If it is below or beside the selected range, edit the rule and expand the source. Then return to the dropdown cell and check that the new choice appears.
Some cells have a dropdown and others do not. The rule may apply to only part of the intended range, or different rules may be assigned to different cells. Inspect the affected cells’ rules and update Apply to range so the intended cells are covered. If you are unsure which rule is causing a conflict, correct one small test range first, then apply the approach to the rest.
An existing value looks wrong after adding validation. Review it against the allowed options. Validation does not automatically replace old entries with a matching choice. Select a valid option or correct the value, then check whether other cells in the range contain similar exceptions.

Frequently Asked Questions

Can I create a dropdown from choices in another tab?
Yes. Choose Dropdown (from a range), then use the range picker to select the cells on the other tab. Confirm the source and test the dropdown after saving. If you move or reorganize the list later, recheck the source range.

Can I add a dropdown to an entire column?
Yes. You can apply a rule to a column or a practical range of rows. If the first row is a heading, exclude it—for example, apply the rule from row 2 downward. A defined range can also help avoid putting dropdowns in cells that are not part of the data.

How do I edit or remove a dropdown?
Select a cell covered by the rule and open Data > Data validation. Edit the choices, source range, display style, or invalid-data behavior and save. To remove a rule, select its remove or delete option in the rule editor. Check the affected range so you do not remove validation from more cells than intended.

Can users type a choice instead of selecting it?
That depends on the invalid-data setting. Reject input blocks values outside the list, while Show a warning allows an unlisted value but flags it. For a consistent shared tracker, rejection is usually appropriate; for flexible records, a warning may be more useful.

Can a dropdown show colored options?
Yes. The Dropdown editor can assign colors to choices, and the display style can show the selected value as a colored chip. Colors are a visual aid, not a substitute for clear option names, and the text remains important for accessibility and printing.

Will changing a dropdown option update cells that already use it?
Changing the text in a source range changes the available list, but it does not necessarily revise values already selected in other cells. Review existing entries if you rename or remove an option, especially if the sheet uses those values for filters or reports.

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.