How to Add a Dropdown in Google Sheets: Step-by-Step

To put a dropdown in Google Sheets, select the cell or range, choose Data > Data validation > Add rule, set the criteria to Dropdown or Dropdown (from a range), enter or select the choices, and click Done. A dropdown lets people choose from a controlled list instead of typing a value from scratch, which can make a shared sheet easier to fill in and sort. These steps are for Google Sheets in a web browser; the menus may look different in the mobile app.

What You’ll Need

A Google account with permission to edit the spreadsheet. View-only access does not let you create or change a dropdown rule.
A spreadsheet open in Google Sheets in a web browser.
The choices you want to offer. You can type them into the rule or put them in a range of cells first.

If you are using a range as the list, decide where those source values will live before you create the rule. You can keep them on the same sheet or put them on a separate tab so the working area stays tidy.

Step-by-Step

Select where the dropdown should appear. Click one cell to add a dropdown there. To apply the same rule to several cells, drag across the cells or select a range by clicking its first cell and then Shift-clicking its last cell. You can also select a whole column if every cell in it should use the same list. Check the selection carefully: the range shown in the name box above the grid helps confirm which cells you have highlighted.
Open the data validation panel. With the target cells selected, choose Data > Data validation from the top menu, then click Add rule in the panel. Google Sheets may also offer a quick route through Insert > Dropdown; either route creates a dropdown rule. The Data menu is useful when you want to manage a rule for an existing range or review its validation settings.
Confirm the cells the rule applies to. In the side panel, check Apply to range. It should show the cell or range you selected. If it does not, enter the correct range or use the range selector to choose cells on the sheet. Be precise with the start and end cells: a rule applied to A2:A20 will not automatically cover A21 or a different column.
Choose how to provide the list. Under Criteria, select Dropdown to enter choices directly, or select Dropdown (from a range) to use values already stored in cells. The first option is convenient for a short, rarely changing list. A source range is usually easier to maintain when choices may be updated or reused in several places.
Enter typed options or select a source range. For a typed list, enter each choice in its own option field, such as Pending, In progress, and Complete. Use the control to add another option, and remove any unwanted row. For a range-based list, provide the range containing the choices, such as Lists!A2:A6, or use the range selector to navigate to those cells. If the tab name contains spaces, include single quotes around it in the reference, such as ‘Status options’!A2:A6. Keep the source cells filled with the intended choices and avoid including unrelated notes.
Set the appearance and invalid-entry behavior. If the panel offers display styles, choose the one that suits the sheet: a chip is visually prominent, an arrow signals a menu, and plain text keeps the cell less decorated. You can assign colors to typed options to make statuses easier to scan; colors do not change the underlying choice. In the advanced settings, choose whether invalid data should be rejected or should only show a warning. Rejecting input keeps values within the list, while a warning permits an unusual value after alerting the editor.
Save and test the dropdown. Click Done. Select one of the cells you configured and open its dropdown using the arrow or chip. Choose an option and confirm it appears in the cell. If you selected the reject-input setting, try typing a value that is not on the list to check that the rule prevents it. Testing one cell can catch a wrong range or a missing option before other people use the sheet.
Adjust the rule later if the list changes. Select a cell covered by the rule and return to Data > Data validation. Edit the rule in the panel and click Done. For a typed list, add or change an option there. For a range-based list, update the source cells or change the referenced range. If you add choices below the current source range, expand the range too; otherwise, those new values will not appear in the dropdown.
Apply the rule to more cells when needed. If the dropdown is already set up, select the cell containing it, copy it, select the destination cells, and use Edit > Paste special > Data validation only where that option is available. Alternatively, edit the rule’s Apply to range field to include the additional cells. Check the result in a destination cell so you do not accidentally copy the original cell’s value or formatting along with the rule.

For a practical example, imagine a task tracker with a Status column. You could add a typed dropdown with Not started, In progress, and Done to cells C2:C50. For a longer list of departments, place the names on a separate tab and set the dropdown to read from that range. The first approach is quick to set up; the second makes it easier to maintain one list in a single place.

Common Mistakes

Applying the rule to the wrong cells. Selecting only C2 when you meant C2:C50 leaves the rest of the column without a dropdown. Review Apply to range before saving.
Leaving new list items outside the source range. If the rule uses Lists!A2:A6, an option typed into A7 is not necessarily included. Extend the referenced range to cover it.
Expecting the dropdown to correct existing values. Adding validation does not automatically replace or clean up data already in the cells. Review old entries separately if consistency matters.
Choosing warning behavior when strict choices are required. A warning alerts editors but may still allow an unlisted value. Choose rejection when the data must match the options.
Putting the choices in the target range. If the source list is in the same cells where people need to make selections, it can overwrite useful data or make the sheet confusing. Store source choices in a separate area.

Excel has its own list validation feature, but its commands and dialog are different. These Google Sheets instructions use the Sheets menus and should not be followed as if they were Excel steps.

Tips

Use a source range for lists that change. A separate list tab gives you one place to add, remove, or rename choices. Keep the range reference aligned with the actual list so updates are available to editors.
Use clear, distinct option names. Choices such as Open, In progress, and Complete are easier to interpret than abbreviations that only the sheet owner understands. Avoid near-duplicates such as Waiting and Wait unless they mean different things.
Label the column and explain exceptions. A heading such as Status tells people what the dropdown represents. If you allow warnings so editors can enter exceptions, add a note or nearby instruction explaining when that is appropriate.
Think about sorting and filtering. Consistent values make it easier to filter a column and summarize records. If two options differ only in spelling or spacing, Sheets treats them as different text, so tidy the list before sharing it.
Keep the source list easy to find and maintain. A clearly named tab such as Lists is more manageable than scattered values on an unrelated sheet. If other editors need to maintain choices, make sure they have permission to edit the source cells too.

Troubleshooting

The dropdown arrow or chip is not visible. Click the cell once and check whether a dropdown appears on selection. Then open Data > Data validation and confirm a rule exists for that cell. If the rule applies to a different range, correct Apply to range and click Done. Also confirm that you have edit access; a viewer may be able to see the sheet but cannot change its rules.

The list is empty or missing an option. Inspect the source range in the rule and verify that it points to the intended tab and cells. Check that the source cells actually contain the choices, and expand the range if the list has grown. A misspelled tab name or a range that starts on the wrong row can make the menu show unexpected results.

An unlisted value is still accepted. Edit the validation rule and review its invalid-data setting. A warning is not the same as blocking entry; choose the reject option if users should only submit listed values. Also check whether the cell has a rule at all, especially if the value was entered in a neighboring cell outside the applied range.

Some cells have a dropdown and others do not. Review the exact coverage shown under Apply to range. Add the missing cells to the range or copy only the validation rule to them. If cells have different rules, inspect each affected area and decide whether to replace those rules with one consistent range.

The rule will not save or the menu is unavailable. Confirm that the spreadsheet is not open in view-only mode and that you are signed in to an account with editing permission. If a shared sheet is being edited by several people, refresh the browser and reopen the validation panel. Before changing a complicated shared sheet, consider making a copy so you can safely review the result.

Frequently Asked Questions

Can I make a dropdown with options I type myself?
Yes. Select the destination cells, go to Data > Data validation > Add rule, choose Dropdown, and enter each option in the panel. Click Done to save it.

Can the dropdown use options from another sheet tab?
Yes. Choose Dropdown (from a range) and select the cells on the other tab. A reference might look like Lists!A2:A10; if the tab name includes spaces, enclose the name in single quotes, as in ‘Team lists’!A2:A10.

Can I put the same dropdown in an entire column?
Yes. Select the intended column or a defined range of rows before adding the rule, then confirm the coverage in Apply to range. A defined range such as C2:C500 can be easier to manage than including the header cell or applying a rule to cells that do not need it.

Can I change a dropdown after creating it?
Yes. Select a cell covered by the rule and open Data > Data validation. Edit the options, source range, display style, or invalid-entry behavior in the panel, then click Done. For a range-based menu, you may instead update the source cells.

Can people type a value that is not in the list?
That depends on the rule’s invalid-data setting. Choose rejection to block unlisted values, or a warning to alert editors while allowing an exception. If you need dependable, consistent entries, rejection is generally the clearer setting.

Do dropdowns work the same way in Excel?
No. Excel has list-based data validation, but it uses different menus and settings. Follow instructions written specifically for Excel when building a dropdown there; the steps on this page are for Google Sheets in a web browser.

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.