Dropdown Menu in Google Sheets: Create and Manage Lists

To create a dropdown menu in Google Sheets in a browser, select the cell or cells, choose Insert > Dropdown, add the choices in the side panel, and click Done. You can also create a list whose choices come from a range of cells, then decide whether invalid entries should be rejected or merely flagged.

What a Google Sheets dropdown does

A dropdown gives people a set of defined choices for a cell. Instead of typing a department, status, or priority from scratch, a user picks an approved value such as In progress or Complete. This can reduce spelling differences and make a sheet easier to filter, summarize, and review.

A dropdown is a data-validation rule, not a separate worksheet or a formula. The rule applies to selected cells and can provide a menu when a user edits them. A cell can still be blank unless you separately require a value through your workflow; adding a dropdown alone does not make the field mandatory.

Dropdowns are useful for project statuses, request categories, staff names, inventory conditions, and other fields where the possible answers are known. They are less suitable when users need to enter unrestricted notes or when the valid choices change constantly and are difficult to maintain.

Create a dropdown with typed choices

For a short list that is unlikely to change often, enter each choice directly in the rule. In Google Sheets on the web:

Select one cell or a range that should use the dropdown. You can select a whole column if the rule should apply to future entries there, though applying a rule to an unnecessarily large area can make a sheet harder to manage.
Choose Insert > Dropdown. Alternatively, choose Data > Data validation to open the validation controls.
In the rule editor, check the range under Apply to range, then set the criteria to Dropdown if it is not already selected.
Enter each choice as an option. Use Add another item to create additional choices. For a task tracker, for example, the options might be Not started, In progress, Waiting, and Complete.
Optionally assign colors or adjust the display and invalid-data settings. Click Done to save the rule.

To use the menu, select a cell with the rule and choose an item from its dropdown. Depending on the display style, the choices may appear as a colored chip, a small arrow menu, or plain text. A dropdown indicator can be easier to see when the cell is selected than when it is not.

Use a range as the source of choices

If the choices are already listed in cells, or are likely to change, use a dropdown based on a range. Put the allowed values in a source list, preferably in a clearly named area or on a separate tab such as Lists. Then select the destination cells, choose Insert > Dropdown or Data > Data validation, and set the criteria to Dropdown (from a range). Enter or select the source range and save the rule.

For example, a source list might contain four department names in Lists!A2:A5, while the dropdown rule applies to entries in Requests!C2:C200. The menu then draws its choices from the list cells rather than from individually typed options. This is convenient when several columns or tabs need to use the same set of values: maintain the source list instead of editing every rule separately.

Keep the range accurate. If the rule points to A2:A5, adding a new value in A6 does not automatically mean the rule includes it. Update the range when the list grows, or choose a sufficiently sized range if that suits the sheet. Avoid including headings or unrelated values, since those can become selectable choices. A source list should also avoid unintended blank rows, which can create confusing empty options.

Choose how the dropdown appears

Google Sheets offers display styles for dropdowns, including Chip, Arrow, and Plain text. A chip presents a choice as a colored label in the cell, which makes statuses easy to scan. Arrow style gives a more compact indicator, while plain text makes the cell look closer to an ordinary text entry. The best choice depends on how prominent the field should be and how much space is available.

Colors can help distinguish categories, but they should reinforce clear wording rather than replace it. For example, label a chip Complete instead of relying on green alone. A sheet may be viewed on different screens, printed, or used by someone who cannot easily distinguish particular colors, so the text should carry the meaning.

Some dropdown rules also offer Allow multiple selections. When available, this lets a user select more than one option in a cell, with the selections displayed together as chips. The setting is intended for chip-style dropdowns, and Google Sheets does not support selecting multiple dropdown options on mobile devices. Use a multi-select list only when the values genuinely belong together; it can complicate filtering and downstream summaries because several choices share one cell.

Edit, copy, or remove a dropdown rule

To change an existing dropdown, select a cell governed by the rule and open Data > Data validation. In the validation panel, select the relevant rule, edit its options, range, or settings, and save the change. If the rule applies to multiple cells, verify the Apply to range field before editing so you understand which cells will be affected.

To apply a rule elsewhere, copying a cell with its validation and pasting it can be a quick approach, but check the destination afterward. A normal paste may copy more than the dropdown, such as formatting or existing cell contents. If you only want a rule, use the validation controls to set it on the destination range rather than unintentionally replacing useful data.

To remove validation, select the affected cell or range, open Data > Data validation, select the rule, and remove it in the panel. Clearing a cell’s contents is different: it empties the value but does not necessarily remove the dropdown rule. Likewise, changing a cell’s color or text does not edit the validation settings.

Reject invalid entries or show a warning

A validation rule can determine what happens when someone types a value that is not on the list. The reject-input setting prevents an unlisted value from being accepted through normal cell editing. The warning setting allows the value but flags it, which is useful when the list is a guide rather than a strict boundary. The exact controls appear in the rule editor under the advanced settings for the dropdown.

Choose rejection when consistent categories are essential, such as a fixed set of workflow statuses. Choose a warning when people may need to record an exceptional case or when the source list is still being developed. In either case, explain the choices in the sheet if their meaning is not obvious. Validation can prompt or restrict ordinary edits, but it is not a security measure: it does not control who can view the sheet, and collaborators with editing access may be able to change the rule or the source data.

If the sheet contains sensitive or important information, use sharing permissions and, where appropriate, Data > Protect sheets and ranges to limit who can edit relevant areas. Protection and validation serve different purposes: protection controls editing access to ranges, while validation guides the values entered into cells.

Practical dropdown examples

For a project tracker, a Status column could offer Not started, In progress, Blocked, and Complete. A separate Priority column might offer Low, Normal, and High. Keeping those fields separate makes it easier to filter all blocked work without searching for words embedded in longer notes.

For an order sheet, a Payment method dropdown could list the methods an organization actually accepts. Avoid adding options that imply a payment method is available when it is not. For an intake form, a Request type dropdown can keep categories consistent, while a neighboring Details column remains free text so users can explain unusual requests.

Consider the future use of the data before deciding what belongs in one dropdown. For example, a single value such as High – urgent combines priority and urgency. Separate fields are often more useful if people will sort, filter, or summarize those concepts independently. Conversely, splitting every small distinction into another column can make a simple sheet burdensome; the structure should match the decisions readers need to make.

Common problems and fixes

The menu does not appear: Confirm that the selected cell is included in the rule’s Apply to range. Open Data > Data validation and inspect the rule. A cell that merely looks like another cell may not have the same validation.
A new choice is missing: Check whether the source range includes the cell where you added it. Expand the range in the rule if necessary, and make sure the new value is in the source list rather than beside it.
An unexpected blank choice appears: Inspect the source range for empty cells or formulas that return an empty string. Adjust the source list so it contains only intended choices.
A typed value is rejected: Check for extra spaces, spelling differences, or a value that is not an exact match to an option. If exceptions are allowed, change the invalid-data behavior to show a warning instead of rejecting input.
Colors or labels look inconsistent: Edit the rule and review the option labels and assigned colors. If different cells use separate rules, they may need to be updated individually or given one shared rule over the correct range.

Also distinguish validation from conditional formatting. A dropdown defines allowed or suggested entries; conditional formatting changes how cells look when conditions are met. For example, a dropdown can provide the Complete status, while a separate conditional-formatting rule can color rows based on that status. One feature does not automatically create the other.

Google Sheets dropdowns compared with Excel

Google Sheets and Microsoft Excel both support validation-based lists, but their menus and rule editors differ. The steps above use Google Sheets paths such as Insert > Dropdown and Data > Data validation; Excel instructions and ribbon paths should not be substituted for them. A workbook opened or converted between the programs may also display features differently, so check the rule after moving a file between services.

In Sheets, a range-based source is especially useful for keeping lists maintained in worksheet cells. If a spreadsheet is shared with people who use both Sheets and Excel, use straightforward option labels and test the converted file in the program that will be used for ongoing editing. Do not assume that every display detail or newer dropdown feature will behave identically across both applications.

Frequently Asked Questions

Can I add a dropdown to an entire column in Google Sheets?
Select the column or the intended portion of it before creating the rule, then confirm the Apply to range field. Applying it to a defined range such as C2:C500 can avoid including a header while leaving room for future rows.

Can I make a Google Sheets dropdown allow multiple selections?
Where the option is available in the rule editor, enable Allow multiple selections and use the Chip display style. Multiple selection is not supported on mobile devices, so users may need the desktop browser for that workflow.

How do I change the choices in an existing dropdown?
Select a cell using the dropdown, open Data > Data validation, and edit the rule. For a range-based dropdown, change the source cells or update the referenced range; for typed choices, edit the options in the rule itself.

Can a dropdown be required?
A dropdown does not by itself ensure that every row has a value. It can guide or restrict entries in a cell, but a team still needs a process to identify blanks, such as reviewing incomplete rows or using a separate check.

Why can someone enter a value that is not in the list?
The rule may be set to show a warning rather than reject input, or the cell may not be covered by the rule. Check the invalid-data setting and the Apply to range field in Data > Data validation.

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.