How to Add Multiple Dropdown Menus in Google Sheets

To add multiple dropdowns in Google Sheets, select the cells that should share a menu, choose Insert > Dropdown, add the choices, and click Done. Repeat for cells that need different choices, or apply one rule to an entire range when every cell should use the same list. You can create dropdowns from typed options or a range of cells, which is useful for keeping repeated menus consistent.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
Permission to edit the spreadsheet. View-only access will not let you add or change dropdown rules.
Your dropdown choices, either ready to type into the rule or arranged in cells if you want to use a source range.

Decide first whether your dropdowns should all contain the same choices. For example, a whole Status column might use the same options, while a Priority column needs a different list. Planning this makes it easier to choose the right cells and avoid creating duplicate rules unnecessarily.

Step-by-Step

Choose where each dropdown should go. Open the sheet and identify the destination cells. If you are making a tracker, you might put a status dropdown in C2:C50 and a priority dropdown in D2:D50. Select a range by dragging across its cells, or click the name box above the grid, type a range such as C2:C50, and press Enter. Leave the header row out unless you deliberately want a dropdown in the heading.
Start a dropdown rule. With the destination cells selected, choose Insert > Dropdown. Google Sheets opens a rule editor, usually in a panel on the right. You can also open Data > Data validation to create or manage validation rules. Menu labels or panel layout can shift slightly as Google updates Sheets, but those are the relevant built-in routes.
Enter choices for a typed list. In the rule editor, choose the dropdown option that lets you enter items directly. Edit the initial options or add new ones, then type one choice per option row. For a status list, you could enter Not started, In progress, and Complete. Use short, distinct labels so people can tell the choices apart. Remove any unused blank option rows before saving.
Set how the menu appears and handles entries. If the editor offers display styles, choose the style that suits the sheet, such as a colored chip or an arrow. You can assign colors to options where available, but colors should support the words rather than replace them. Check the invalid-data setting: rejecting input prevents people from entering a value outside the list, while showing a warning allows it but flags the mismatch. Choose the behavior that fits how strictly the sheet needs to follow the list.
Save the first rule. Click Done. Click one of the selected cells to confirm that the dropdown appears and that its options are correct. If the cells do not show a visible arrow until selected, click a cell rather than relying only on its appearance at rest. Try choosing an option to make sure the value is recorded in the cell.
Add another dropdown with different choices. Select the next destination range, such as D2:D50, and again choose Insert > Dropdown. Add the options for that column, for example Low, Normal, and High, then click Done. Each rule applies to the range shown in its editor, so check that range before saving. This is the usual method when different columns or cells need different menus.
Use a source range when you want a reusable list. Put the choices in a column of cells, ideally on a clearly labeled list area or a separate sheet. Select the destination cells, start a dropdown rule, and choose the option for a dropdown from a range. Enter or select the source-cell range in the range field, then save. If you later change the source choices, the dropdown can reflect the updated list. Keep the source cells tidy: blank cells or accidental entries may create unwanted menu options.
Apply one menu to many cells efficiently. Select the full destination range before creating the rule, such as C2:C200, if every cell needs identical options. To add the same validation to another area, copy a cell that already has the rule, select the target cells, then use Edit > Paste special > Data validation only if that command is available in your Sheets menu. This copies the rule without replacing the target cells’ existing values or formatting. Check the pasted cells afterward to confirm the rule covers the intended range.
Review the rules and test the sheet. Open Data > Data validation to inspect or edit rules. Click representative cells in every dropdown range and test a choice. If the sheet has separate lists, test each one; a correctly working status menu does not confirm that the priority menu is set up properly. Consider asking another editor to try the sheet if they will be entering data, since their workflow may expose confusing labels or missing cells.

These steps create multiple dropdown menus across cells or columns. They do not necessarily make several independent menus appear inside one cell. If you mean a dependent dropdown, where the choices in a second menu change based on the first selection, that requires a different setup and may involve helper ranges or formulas.

Common Mistakes

Selecting the wrong range: A rule added to C2 applies to C2, not automatically to the rest of the column. Select all intended cells first, or correct the rule’s apply-to range in the validation panel.
Creating separate rules for every cell: This works, but it is slow and makes later edits harder. When choices are identical, select the whole range and create one rule for it.
Using inconsistent labels: Slight differences such as In progress and In Progress may be treated as different values in later sorting, filtering, or analysis. Decide on wording and capitalization before adding the list.
Leaving unwanted blanks in a source list: Empty cells in a source range can lead to blank-looking choices. Use a compact list without gaps, and keep notes or headings outside the referenced range.
Assuming a dropdown prevents every error: A warning-based rule may still allow non-list text. If entries must be limited to the listed choices, set the rule to reject invalid input and tell collaborators how to use the menu.
Overwriting existing cell contents: Adding a rule normally does not require clearing the destination cells. Be careful when pasting cells or deleting ranges, because those actions can replace existing data as well as affect validation.

Tips

Keep source lists in one place. A labeled section or dedicated list tab makes options easier to find and update. Use clear headings, but do not include the heading cell in the dropdown’s source range.
Use dropdowns for stable, repeated values. Menus work well for status, department, category, or priority fields. For a value that changes constantly or needs free-form detail, a dropdown may slow editors down more than it helps.
Make choices easy to scan. Put the most common choices in a sensible order, use concise wording, and avoid options that overlap in meaning. If color is available, use a restrained scheme and retain descriptive text for accessibility.
Leave room for future rows. If you expect a list to grow, apply the rule to a sufficiently large range, such as C2:C500, rather than only the rows currently filled. For a very large sheet, balance spare capacity against keeping the rule limited to the area people actually use.
Protect the source list when appropriate. If other editors should choose options but not change the options themselves, consider protecting the cells or sheet that stores the source values. Check sharing permissions and protection settings before relying on them to control access.
Remember the Excel difference. This guide uses Google Sheets in a browser. Excel for Microsoft 365 has its own validation controls under Data > Data Validation; its menus and dropdown display options are not identical, so follow Excel-specific steps if the file is being edited there.

Troubleshooting

The dropdown does not appear. Click the cell to see whether its menu indicator appears on selection. Then open Data > Data validation and check that a rule exists and that its applied range includes that cell. A common cause is selecting a neighboring column or omitting the first or last rows.

The menu has the wrong options. Edit the rule and inspect its option rows or source range. With a range-based dropdown, confirm that the reference points to the intended cells and does not include a heading, blank rows, or unrelated values. If the rule is shared by many cells, changing its list can affect all of them.

Some cells work and others do not. The rule may cover only part of the range, or a pasted cell may not have carried its validation. Inspect the applied range in the rule editor. Extend or recreate the rule for the missing cells, then test a cell near each end of the range.

Sheets accepts text that is not in the list. Open the rule and change the invalid-data behavior from showing a warning to rejecting input if the editor needs to be restricted to listed values. If the value was already entered, changing the setting may not automatically clean up existing entries; review those cells separately.

A source range cannot be selected or gives an error. Check that the reference uses a valid range in the spreadsheet and that the source cells are accessible. Try selecting the cells with the range picker instead of typing the reference. If the list is on another tab and direct selection is awkward, place the source list on the same sheet or consult the current range picker guidance in Sheets.

A copied dropdown changes data or formatting unexpectedly. Undo immediately with Ctrl+Z on Windows or ChromeOS, or Command+Z on a Mac, if the edit is still the most recent action. Re-copy the source cell and use the data-validation-only paste option rather than a normal paste. Check important data before repeating the operation.

Frequently Asked Questions

Can I add dropdowns to many cells at once?
Select all the cells in the range before creating the rule. They will share the same choices. If you need different choices in different columns, create a separate rule for each list.

Can every dropdown have different options?
Yes. Select the destination cell or range for one menu, create its rule and choices, then repeat for the next destination with its own choices. You do not have to use the same list throughout the sheet.

Can I make a dropdown from values already in cells?
Yes. Choose the dropdown-from-a-range option in the rule editor and specify the cells containing the choices. Keep that source range organized so edits do not accidentally add blank or irrelevant options.

How do I change or remove a dropdown?
Select a cell covered by the rule and open Data > Data validation. Edit the options or range and save, or remove the rule from the editor. Removing validation is different from clearing the cell’s existing value, so decide whether the selected data should remain.

Can I put two separate dropdowns in one cell?
A standard Google Sheets dropdown rule gives a cell one menu of choices. To collect two separate answers, use two cells, each with its own dropdown. A dependent menu whose options change according to another cell is a separate design, not simply two ordinary menus in one cell.

Will the dropdown work for other people editing the file?
Editors who can change the spreadsheet can normally use its dropdowns. Viewers may be able to see values but cannot enter them. If collaborators cannot edit the cells, check their sharing role and whether the destination cells or sheet are protected.

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.